Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows to columns with a twist
I have a workbook with repeating data in one column and unique data in sets
of 5 rows in the next column: A 1 B 2 C 3 D 4 E 5 A 6 B 7 C 8... etc I would like to transpose to: A B C D E 1 2 3 4 5 6 7 8... etc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows to columns with a twist
I don't recall who's responsible for this equation but it worked along with
some manual manipulation: =INDEX($A:$A,COLUMNS($A:E)+6*ROWS($1:1)-6) Pulling the function along the row transposed the rows in column A to column headers. Pulling the function down one row then to the right one column and then down till the data in the column was all similar data... and repeating until each column was filled with the desired data... worked great. Then I simply copied and "paste special - values' into a new worksheet. Thanks! "bcone" wrote: I have a workbook with repeating data in one column and unique data in sets of 5 rows in the next column: A 1 B 2 C 3 D 4 E 5 A 6 B 7 C 8... etc I would like to transpose to: A B C D E 1 2 3 4 5 6 7 8... etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |