Hi,
I have several €˜sections with up to 4 products (columns), but some sections
have less than 4 products (columns) but the same products. I have hundreds of
sections. How can I align the columns so that the relevant products are all
above each other? Is there any other way to make this data user friendly for
plotting charts/pivot tables? There are hundreds of sections, any suggestions
appreciated. Sample below:

Section 1
Product A Product B Product C
03-Jan-09 150 245
12-Jan-09 280 159
16-Jan-09 366
18-Jan-09 146 86
20-Jan-09 280 99
29-Jan-09 300
30-Jan-09 280 99
Sum: 3922 1916 86
Section 2
Product A Product B Product D
07-Jan-09 189 199
12-Jan-09 169 149 59
21-Jan-09 179 150 59
28-Jan-09 169 221
Sum: 905 906 118
Section 3
Product B Product C
02-Jan-09 170 210
08-Jan-09 230 151
19-Jan-09 155 226
23-Jan-09 200 186
29-Jan-09 180 211
Sum: 1110 1195