Way to put multiple rows into the same column.
- From: "Peter Brown" <Peter Brown@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 30 Mar 2005 17:41:15 -0800
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.
.
- Follow-Ups:
- Re: Way to put multiple rows into the same column.
- From: Alan Beban
- Way to put multiple rows into the same column.
- From: Biff
- re: Way to put multiple rows into the same column.
- From: Mark
- Re: Way to put multiple rows into the same column.
- Prev by Date: What is a spread*** and what is it used for?
- Next by Date: A Macro that will cut and paste to specific cell
- Previous by thread: What is a spread*** and what is it used for?
- Next by thread: re: Way to put multiple rows into the same column.
- Index(es):
Loading
