Way to put multiple rows into the same column.
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Wed, 30 Mar 2005 21:36:44 -0800
Hi!
So you want 1 column 9000 rows long?
Select column A and insert a new column.
Your data will now be in the range B1:D3000.
Enter this formula in cell A1 and copy down to A9000 or
until you get returns of zero meaning the data has been
exhausted:
=OFFSET($B$1,INT((ROWS($1:1)-1)/3),MOD(ROWS($1:1)-1,3))
Now, with this range still selected do a Copy/Paste
Special/Values to convert the formulas to constants.
Then you can delete the original data if you want to.
Biff
>-----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.
>.
>
.
- References:
- Way to put multiple rows into the same column.
- From: Peter Brown
- Way to put multiple rows into the same column.
- Prev by Date: re: Viewing source code when saved as web page
- Next by Date: date as "mmm dd, yyyy" in the header in excel
- Previous by thread: re: Way to put multiple rows into the same column.
- Next by thread: Re: Way to put multiple rows into the same column.
- Index(es):
Relevant Pages
|
