Thread: sorting data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hellomoto Hellomoto is offline
external usenet poster
 
Posts: 1
Default sorting data

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