Combine columns into 1

Hi griffinst 

 You need to unpivot here rather than transpose:

In Power Query, select all of the columns that you want to keep fixed, then select 'unpivot other columns'

Select the 'Attribute' column, then on the home tab select 'Split Column by Delimiter'

Then split by colon, left-most delimiter

You get 2 new columns, call Attribute.1 "Category" and Attribute.2 "Condition".

Close and apply.

Now you can add a visual level filter of Value=1 (or filter out 0s in power query) and a category slicer to display your results!

--------------------------------

I hope this helps, please give kudos and mark as solved if it does!

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!

GeraldGEmerick.  I think that might work but I think I need a merge rather then an append.  The split column worked but I'm not getting the results I need.  Pretty sure I need Columns of "GIC" and "PE" to filter the data correctly.  So then a user can select a GIC filter and a PE filter and both will filter the dataset down to the people who meet both criteria.

see below screenshot... I need the "category" values to be seperate columns with values of "Cat_Detail" then the cooresponding "Value".   ie...   "Gap in Care" column and "Gap in Care Value" column.  and same for "uncontrolled.., and preventable...  Thanks for any help you can provide.