View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juuljus Juuljus is offline
external usenet poster
 
Posts: 31
Default From clumns to rows

Hello everyone,

I have a table. There are headers and below them is data. 3 rows and 10
columns. I need to get this table to change it's format.

from:
a1 b1 c1 d1
a2 b2 c2 d2
a3 b3 c3 d3

to:
a1 a2 a3
b1 b2 b3
c1 c2 c3
d1 d2 d3

Thanks to everyone.

Juuljus