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

v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi George1973 ,

 

You could copy their code into a blank query to take a look at the steps. And then apply them to your own query.

 

 

 

George1973's avatar
George1973
Helper V
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 :))