Forum Discussion

George1973's avatar
George1973
Helper V
5 years ago
Solved

Unpivot Multiple Columns with different formats

Hi All, I'm looking for the easy solution with Power Query for the following task: I have a sample table like given below: ..And I would like to unpivot the "Issues" ans "Score" columns as g...
Need Help
  • George1973's avatar
    George1973
    5 years ago

    Hi,
    v-xuding-msft CNENFRNL Jimmy801 AlB 
    Thanks a lot for your aissists,
    I have solved the issue in my "artificial" way:
    I have imported the same table four times and edited them according the need:
    Fist table - I have left there the basic columns and then first columns for 1st question and 1st score.
    then I have did the same with the second table leaving there basics and columns for 2nd questions ans scores and so on..
    Then I have just UNION all four tables :)))))
    That's all :))

AlB's avatar
AlB
Community Champion
5 years ago

Hi George1973 

Can you please show your data in text-tabular format in addition to (or instead of) the screen captures? Particularly the first table.  A screen cap doesn't allow people to readily copy the data and run a quick test.  Just use 'Copy table' in Power BI and paste it here.

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers