|
Excel - rows to columns?
I'm using a microstrategy tool that pulls info from a huge database for me to then filter down and mess about with to my heart's content. Only problem with the tool is that when I ask it to retrieve information based on more than one subheading it produces me the information in row form making it impossible to filter, sort, pivot etc. Does anyone know a trick I can use to switch rows to columns?
Many thanks.
__________________
Can I be dreaming, or am I just coping?
|