Pivot table -> turn columns into rows

Hello,

I have a table in the following format:

Each record consists of a model of shoe we will produce, and the number columns are the sizes (Brazilian sizes). So we have sizes 33,34,35,36,37,38,39,40. In the size columns we have the quantity we will produce for each size.

The column supplier is the supplier who will produce

I would like to make a pivot table with the following information:

Supplier Size Quantity
Sup #1 33 0
Sup #1 34 16
Sup #1 35 17
Sup #1 36 18
Sup #1 37 25
Sup #1 38 16
Sup #1 39 12
Sup #1 40 0
Sup #2 33 5
Sup #2 34 12
Sup #2 35 16
Sup #2 36 19
Sup #2 37 24
Sup #2 38 17
Sup #2 39 13
Sup #2 40 7

The reason why, is that i want to visualize the data in the first format, but export a csv in the second format.

Any idea how to do it?

Thank you

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.