How to Unpivot merge columns

[PBI_newuser]

Hi, I have a set of data with merge "month" column. How to unpivot it to have the expected output?

Raw Data:

	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21
Name	Customer Count	Sales Amount	Customer Count	Sales Amount	Customer Count	Sales Amount	Customer Count	Sales Amount	Customer Count	Sales Amount	Customer Count	Sales Amount
A	3	564566	8	789789	2	564566	3	789789	8	564566	2	789789
B	5	678678	6	345564	2	678678	5	345564	6	678678	2	345564
C	6	234234	3	232342	5	234234	6	232342	3	234234	5	232342
D	2	678678	5	567567	9	678678	2	567567	5	678678	9	567567
E	5	345345	2	345456	7	345345	5	345456	2	345345	7	345456

Expected Output:

Name	Month	Customer Count	Sales Amount
A	Oct-20	3	564566
B	Oct-20	5	678678
C	Oct-20	6	234234
D	Oct-20	2	678678
E	Oct-20	5	345345
A	Nov-20	8	789789
B	Nov-20	6	345564
C	Nov-20	3	232342
D	Nov-20	5	567567
E	Nov-20	2	345456
A	Dec-20	2	564566
B	Dec-20	2	678678
C	Dec-20	5	234234
D	Dec-20	9	678678
E	Dec-20	7	345345

[FarhanAhmed · Accepted solution]

Hi,

Can you please check if attached PBIX file contains the solution you are looking for.

The steps that need to be applied are