Converting wide data to long in Excel & Google Sheets

Various means for converting wide data to long data in Excel and Google Sheets.

[Alapnea]

This is exactly what I needed to convert the data! Thank you so much :D

[GyurkaJansen]

Great! Exactly what I need to get some simple data ready to include in Looker.

[ads]

Really such a good video! I thought it was only about Excel, but actually it also explains how to achieve the same result on Google Sheet, which is exactly what I needed. This video even extends the content to Tableau extension in Excel! So detailed and well-explained!
If MJ could modify this video' title a bit, including more detailed key words in it, I think more people will come to watch it, in return will help more people.


❤

[JmanJarquise]

oh hell yeah to the google sheets solution. I added indirect() to the array formulas to make it dynamic. Worked like a charm. Thank you so much.

[vaibhavsahdev]

Thank you. Explained well and at the right speed

[nhdatadiva]

Thank you!!! I can now stop banging my head against my computer screen. 😉