sorting data
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" wrote in message
...
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
|