Power Query-Pivoting multiple columns to rows

Question

HI 

I need help in power query- pivoting selected columns to rows.  In the file below, if you see the data source, some column fields I need for slicers are coming in a column format where I need it rows so I could do slicers.  Whenever I unpivot the selected columns it impacts other columns and I get this below in the attached image where the values are repeating in row.  Basically, if you see the pivot slicer tabs, that is the grouping I need.  this is just a dummy file as example

Grouping that I want to see in the slicers from power query columns:

Days-d30,d60,d90 columns to rows

Brand: FD,HS,MM,OT columns to rows

Arrang: ARR, SETT, SIN columns to rows

date: is already in the row dont need to do anything

PDT: is already in the row don't need to do anything

File Below:

https://1drv.ms/x/s!AmxTHYioikr1lBhoBQu3vOu1v\_zp?e=URvwz9

Answer 1

Hi Ashish-

Please see below the image: this is the exact result I want to see in the tabular format from the file.

File below just in case to see the data and this image:

https://1drv.ms/x/s!AmxTHYioikr1lBxtt4Hfjv0w1ELF?e=UzWXJk

Answer 2

For the MM row (Attribute 2 column), why are there no entries for the other columns?

Answer 3

Sorry--you said three columns so didn't want to do more than that to confuse you but there should be entries as well for that row.

Answer 4

Hi,

We need to get on a call to understand this better.  Please send me an e-mail from the contact me page of my website - Contact Me (ashishmathur.com)