| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data | Excel Discussion (Misc queries) | |||
| sorting data | Excel Discussion (Misc queries) | |||
| Sorting data to match existing data | Excel Discussion (Misc queries) | |||
| colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
| Data Sorting | Excel Worksheet Functions | |||
Threaded Mode
