Dates as column headers transforming into rows

[maati1980]

My input data has Years and month date as a column header. Can I transpose it into rows?

To illustrate my data has the following form:

Customer	Product	2018.01	2018.02
Customer A	Product 1	1	2
Customer A	Product 2	3	4
Customer B	Product 1	5	6
Customer B	Product 2	7	8

and I would like to get:

Customer	Product	Time	Sales
Customer A	Product 1	2018.01	1
Customer A	Product 2	2018.01	3
Customer B	Product 1	2018.01	5
Customer B	Product 2	2018.01	7
Customer A	Product 1	2018.02	2
Customer A	Product 2	2018.02	4
Customer B	Product 1	2018.02	6
Customer B	Product 2	2018.02	8

Is it possible?

[Anonymous · Accepted solution]

Query Editor

Select Costumer and Product

Right Click

Unpivot Other Columns

or Pivot, I am not sure