Forum Discussion

MatH's avatar
MatH
Frequent Visitor
4 years ago
Solved

Combining multiple columns whilst keeping ID/Date

Hi   I have a table that looks something like this:   I wanted to have one long list of all the subtypes, ideally keeping them with the correct date and ID's.   Using some other posts fro...
Need Help
  • Avantika-Thakur's avatar
    Avantika-Thakur
    4 years ago

    Hi MatH ,

    You will have to follow the below steps :

    1) Unpivot by selection only the columns - Reason Type 1, Reason Type 2, Reason Type 3, Reason Type 4. It will give you the below result

    2) Filter ou the Blank rows from the column -"Value" to get the below table

    Hope this helps.

    Please accept the solution if this answers your query.

    Thanks!

    Avantika

Avantika-Thakur's avatar
Avantika-Thakur
Solution Supplier
4 years ago

Hi MatH ,

You will have to follow the below steps :

1) Unpivot by selection only the columns - Reason Type 1, Reason Type 2, Reason Type 3, Reason Type 4. It will give you the below result

2) Filter ou the Blank rows from the column -"Value" to get the below table

Hope this helps.

Please accept the solution if this answers your query.

Thanks!

Avantika

MatH's avatar
MatH
Frequent Visitor
4 years ago

Thank you - this is effectively what I had tried but missed the simple last step of filtering out those blanks. Much appreciated