Hello. I have a spreadsheet with thousands of rows for different product and I have four categories on the columns. Each of the categories has a year (1-7). I would like to transform this information so that I could use it in a powerpoint. I've attached a sample. Keep in mind that in the original there are thousands of rows. I tried doing pivottable wizard, multiple consolidation ranges, and then double clicking totals but that only seems to work for one variable. Thanks!!
Bookmarks