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/$$