Thread: Excel - rows to columns?
View Single Post
  #7 (permalink)  
Old 22nd May 2008, 09:16 AM
Redder Lurtz's Avatar
Redder Lurtz √ Redder Lurtz is online now
Smeg and the Heads
  
Join Date: Jan 2008
Location: Mordor
Posts: 4,246
vCash: 500
iTrader: (0)
Redder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the ProclaimersRedder Lurtz rules harder than the Proclaimers
Re: Excel - rows to columns?
Ok, hope this helps. The first column here is four rows deep, the second column is two rows deep and the thirs one row. The report generates in Microstrategy which I then export to Excel. The report, once exproted, gives the first two columns as merged cells: (This is dummy data which means cock all btw)


URN 1 Red 2565
2148
Green 4112
225
URN 2 Red 458
4512
Green 1585
1787
URN 3 Red 135
165
Green 1511
1658
URN 4 Red 1332
3367
Green 1124
1145
__________________
Can I be dreaming, or am I just coping?
Reply With Quote