Hi All,
Requesting help in getting the output from the below table
ID | Type |
101 | A|B|C |
102 | A|C |
103 | B|C |
104 | B|A|C |
105 | D|A|C|B |
106 | C|D |
Output:
ID | Type | A Type | B Type | C Type | D Type |
101 | A|B|C | A | B | C | |
102 | A|C | A | NA | C | |
103 | B|C | NA | B | C | |
104 | B|A|C | A | B | C | |
105 | D|A|C|B | A | B | C | D |
106 | C|D | NA | NA | C | D |
Solved! Go to Solution.
Hi @Manjari
In addtion to @atcodedog05 solution, I created the one with "NA" for missing values.
As I see in your desired output that you do not want to display NA if it is missing on last place (I mean column D Type).
Let me know if it is something you look for.
Regards,
Karolina
Thank you @atcodedog05 and @KarolinaRoza for the prompt response.
Both the solutions worked like a charm.
Happy to help : ) @Manjari
Cheers and have a nice day!