Raw data output is poor excel format part 2 - align columns


A

aquaxander

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 don’t 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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top