Make combination of rows as column

[wafiyanwary]

Hi,

I've done lots of research but still could not find a solution on this. Need to have the outcome per the "expected outcome" sheet. my raw data are in the "existing" tab.

Appreciate if anyone could help, thanks!

[huynv96 · Accepted solution]

Here it is

[wafiyanwary]

Thank you so much! It was really helpful 🙂