Forum Discussion

rohanraher's avatar
rohanraher
Regular Visitor
2 years ago
Solved

Transform columns without a qualitative column

Hi community,   I am trying to transform a table using Power Query but not able to achieve the desired result. I am posting an example of the data set below for referral, can anyone please help me ...
Show and Tell
  • Syk's avatar
    Syk
    2 years ago

    Select all your columns and under transform, unpivot columns.

    Then in your new attribute column, filter out all the rows that contain "Total". Then you can split the attribute column to get your remaining info such as a business name column and so on.

Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Select all your columns and under transform, unpivot columns.

Then in your new attribute column, filter out all the rows that contain "Total". Then you can split the attribute column to get your remaining info such as a business name column and so on.