Forum Discussion
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 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.
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
2 Replies
Avantika-ThakurSolution Supplier
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
Thank you - this is effectively what I had tried but missed the simple last step of filtering out those blanks. Much appreciated
