Hi everyone,
I currently have a spreadsheet with over 30k cells of data. My issue is that I need to organize it in a way that I can use a pivot table, currently the spreadsheet looks like the following,
Rows: Items
Columns: stores
Body: Sales
I would like to put this into columns, my only problem is that each store carries x amount of items, does that mean that I would need to have a column for each store with a column for the items and then sales?
for example:
store 1/item1/$$
store 1/item2/$$
Bookmarks