View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Transpose data into a single cloumn

Does Row1 contain headers? If so, why aren't you transposing them in
Col1?

Can each row go in the next Col, or do they need to be stacked for some
reason?

This would give the following layout...

H R R
e o o
a w w
d 2 3
i D D
n a a
g t t
s a a

...and so forth across the sheet.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion