Transpose single row containing semicolon separated values to column

Sure! Here it is!

Example.xlsx

Three sheets: "What I have", "What I need" (first-best solution); "Acceptable" (second-best solution if first -best too difficult).

Thanks a lot!