Reply to thread

Message: [QUOTE="aquaxander, post: 13026673"] 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 [/QUOTE]