Unpivot selected columns with values are not working and getting error on all the columns.

[dinesharivalaga]

Hi Experts,

I am trying to do Unpivot selected columns from power query and it is not working and getting error on all the columns.

I want to make a header as a column and values as a other column to plan for some visual.

Before:

After selected all the above 3 columns and clicked "Transform -> Unpivot only selected columns"

All the other columns also getting error and don't know what's happening ..

Please help to achieve on this ..

Thanks

DK

[Keezz]

What is the error you get? (click in the preview table to the left of the word "Error")

[PhilipTreacy]

@dinesharivalaga 

Please provide the data you are using.  Hard to debug without it.

Regards

Phil