Combining multiple columns whilst keeping ID/Date

[MatH]

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 from here I tried unpivoting but it doesn't seem to have worked instead just giving me each subtype for every ID, where this wouldn't be the case.

[Avantika-Thakur · Accepted solution]

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]

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