Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Raw data output is poor excel format part 2 - align columns
Hi,
Having solved part 1. I now have up to 4 columns of data for each section (with a total column as well) which represent 4 different products. The system that has churned out this data has always put the products in the same order but some sites dont do certain products, so the column for a particular product is omitted. Is there any way I can €˜align the columns so that I can use the data for a pivot table? See sample below (there are over 1,000 sites!) A1 Vehicles Product A Product B Product C Product D Total A1 Vehicles 03-Jan-09 15 25 40 A1 Vehicles 06-Jan-09 20 19 39 A1 Vehicles 07-Jan-09 20 19 39 A1 Vehicles 08-Jan-09 20 19 39 A1 Vehicles 09-Jan-09 28 10 38 A1 Vehicles 12-Jan-09 28 16 44 A1 Vehicles 14-Jan-09 20 19 39 A1 Vehicles 16-Jan-09 37 37 A1 Vehicles 18-Jan-09 15 9 23 A1 Vehicles 20-Jan-09 28 10 38 A1 Vehicles 21-Jan-09 28 10 38 A1 Vehicles 23-Jan-09 28 10 38 A1 Vehicles 26-Jan-09 28 9 37 A1 Vehicles 27-Jan-09 20 19 39 A1 Vehicles 29-Jan-09 30 7 37 A1 Vehicles 30-Jan-09 28 10 38 Sum: 392 192 9 7 599 Abbey Service Product A Product B Product D Total Abbey Service 07-Jan-09 19 20 39 Abbey Service 12-Jan-09 17 15 6 38 Abbey Service 15-Jan-09 20 19 39 Abbey Service 21-Jan-09 18 15 6 39 Abbey Service 28-Jan-09 17 22 39 Sum: 91 91 12 193 ABC Motors Product A Product C Total ABC Motors 02-Jan-09 17 21 38 ABC Motors 08-Jan-09 23 15 38 ABC Motors 13-Jan-09 18 21 39 ABC Motors 19-Jan-09 16 23 38 ABC Motors 23-Jan-09 20 19 39 ABC Motors 29-Jan-09 18 21 39 Sum: 111 120 231 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Raw data output is poor excel format part 1 | Excel Discussion (Misc queries) | |||
Format and Align Columns | New Users to Excel | |||
Filtering Columns to Align Matching Data | Excel Worksheet Functions | |||
format cell from data input to output form | Excel Worksheet Functions | |||
excel data label format special number characters (part 2) | Excel Discussion (Misc queries) |