If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
sorting data
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).EntireRo w.Delete End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|