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 :))

Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello George1973 

 

choose the first two columns, and select the function "Unpivot other columns"


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

George1973's avatar
George1973
Helper V
5 years ago

Hi, sorry I forgot to mention that "Issue" field is in text format and the "score" filed are in numbers