You can find how to Unpivot In Google Sheets With Formulas (How To Turn Wide Data Into Tall Data) in it.
You've already known that not every formula cannot convert GS to Excel vise vasa.
In the GS you can find the formula in cell G4:
=ArrayFormula(SPLIT(FLATTEN(B1:E1&"🦊"&A2:A4&"🦊"&B2:E4),"🦊"))
How you can convert it in Excel.
You can use TOCOL() instead of FLATTEN()
But you have to use TEXTSPLIT(TEXTJOIN()) in Excel to get the solution.
