Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
columns to rows
I have a file with a great deal of data (though my data will not exced the
limit once arranged in rows) that I need to transpose from column to row based on column A. Data is arranged as follows: ID Day Pct Day Pct Day Pct Day Pct 55462 Monday 45 Tuesday 55 135464 Friday 20 Wednesday 20 Thursday 60 15448 Thurs 20 Monday 20 Friday 20 Wednesday 40 1487 Monday 30 Tuesday 20 0PA 50 My goal: ID Day Pct 55462 Monday 45 55462 Tuesday 55 135464 Friday 20 135464 Wednesday 20 135464 Thursday 60 15448 Thurs 20 15448 Monday 20 15448 Friday 20 15448 Wednesday 40 1487 Monday 30 1487 Tuesday 20 1487 Saturday 50 Any assistance is appreciated. |
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) |