View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zuo Zuo is offline
external usenet poster
 
Posts: 24
Default Copying data from 205 columns to 1 column

Hi,

I am using Excel 2007 and have a table that has 205 columns and 15 rows. I
want to copy the data of the 15 rows of every column under Column A with a
blank row between the data of every column.

Example:

A B C
A1 B1 C1
A2 B2 C2
A3 B3 C3

B1
B2
B3

C1
C2
C3

I appreciate if somebody can help with this. If this question has been
posted before, please direct me to the post.

Thanks,
Zuo