Prev: Jpeg links opening in Explorer instead of Picture Manager
Next: Filling formulas with specific cell references remaining the s
From: Hellomoto on 25 Mar 2010 14:46
I have a column of data that repeats every 10 rows. that is, the data type
is repeated every ten rows. I want to reorganize the data in that column into
10 columns (one column for each row). How can i accomplish this?

example: I want to distribute column A:
column A
date1
name1
age1
date2
name2
age2
etc...

into separate columns:

Column A Column B Column C ...etc
date1 name1 age1
date2 name2 age2

Thank you in advance
From: Don Guillett on 25 Mar 2010 14:58
One way. You could also do with a loop within the loop
Sub transposeem()
For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row Step 3
Cells(i, 1).Resize(3).Copy
Cells(i, 2).PasteSpecial Paste:=xlPasteAll, Transpose:=True
Next i
Columns(1).Delete
Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Hellomoto" <Hellomoto(a)discussions.microsoft.com> wrote in message
news:5F64B12A-E7BB-4709-B12B-E54F2C274E9C(a)microsoft.com...
>I have a column of data that repeats every 10 rows. that is, the data type
> is repeated every ten rows. I want to reorganize the data in that column
> into
> 10 columns (one column for each row). How can i accomplish this?
>
> example: I want to distribute column A:
> column A
> date1
> name1
> age1
> date2
> name2
> age2
> etc...
>
> into separate columns:
>
> Column A Column B Column C ...etc
> date1 name1 age1
> date2 name2 age2
>
> Thank you in advance

From: Ashish Mathur on 25 Mar 2010 21:46
Hi,

Download and install ASAP utilities (simply Google ASAP utilities). Then
create a copy of the data range. Now select the data and go to ASAP
utilities > Columns+Rows > Transpose column in multiple steps. Type number
3 in the box and click on OK

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Hellomoto" <Hellomoto(a)discussions.microsoft.com> wrote in message
news:5F64B12A-E7BB-4709-B12B-E54F2C274E9C(a)microsoft.com...
> I have a column of data that repeats every 10 rows. that is, the data
> type
> is repeated every ten rows. I want to reorganize the data in that column
> into
> 10 columns (one column for each row). How can i accomplish this?
>
> example: I want to distribute column A:
> column A
> date1
> name1
> age1
> date2
> name2
> age2
> etc...
>
> into separate columns:
>
> Column A Column B Column C ...etc
> date1 name1 age1
> date2 name2 age2
>
> Thank you in advance

 | 
Pages: 1
Prev: Jpeg links opening in Explorer instead of Picture Manager
Next: Filling formulas with specific cell references remaining the s