re: Way to put multiple rows into the same column.

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi,

Try my EastyText_Rev1.xls at
http://www.geocities.com/excelmarksway

It might work, er, maybe, hmmm...

- Mark



>-----Original Message-----
>I have data that is in the format of 3 columns wide by
about 3000 rows. I
>want to rearrange each row to become a single column. Eg.
Cells
>A1,B1,C1,A2,B2,C2 to become in cells A1,A2,A3,A4,A5,A6
respectively. I have
>transposed the data but this only puts each row in it's
own column. I still
>need to put all the new columns into one column. Thankyou
for any help given.
>.
>
.


Quantcast