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!

exchange rate.xlsx

huynv96

Here it is

solution.yxzp