Split the unique row into multiple rows in a new table based on the the Y/N columns

[Anonymous]

Hi All,

I am looking to split the unique row into multiple rows in a new table based on the Y/N columns to the unique data. For examaple I would like to have two rows the Incident ID "3256031" with a column veh Type with Car and Good vehicle in it.

Current data

Required Output:

Thanks for your help in  advance.

Thanks and regards

Gautam

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can try doing thiss in Query Editor in Power BI.

Consider following smaple data:

Then selected the Car and Goods Vehicle columns and Unpivot them:

You end up following:

 You can rename the resulting columns as per your requirement.

Thanks,

Pragati