Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transposing/combining columns with 2 headers
I'm having trouble transposing a spreadsheet with 2 column headers (dates for
the month across, with three sub columns beneath). I assume I'll need a VB solution, but don't know how to construct them. Here is what I my original data file looks like: 1-Dec-07 1-Dec-07 1-Dec-07 2-Dec-07 2-Dec-07 2-Dec-07 Page View Sessions Visitors Page View Sessions Visitors LNX Code1 0 0 0 0 0 0 LNX Code2 20 1 1 10 2 2 LNX Code3 529 49 49 1756 109 107 LNX Code4 5294 431 431 4704 362 361 I want it to read like this: Page View Sessions Visitors LNX Code1 1-Dec-07 0 0 0 2-Dec-07 0 0 0 LNX Code2 1-Dec-07 20 1 1 2-Dec-07 10 2 2 LNX Code3 1-Dec-07 529 49 49 2-Dec-07 1756 109 107 LNX Code4 1-Dec-07 5294 431 431 2-Dec-07 4704 362 361 Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transposing columns | Excel Discussion (Misc queries) | |||
Transposing three columns into one row after manipulating data in columns | Excel Discussion (Misc queries) | |||
Stuck on combining two lists with different column headers | Excel Discussion (Misc queries) | |||
Excel 2007 extra columns - but transposing columns still not working! | Excel Programming | |||
Transposing selected column headers | Excel Programming |