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. ❤
This is exactly what I needed to convert the data! Thank you so much :D
Great! Exactly what I need to get some simple data ready to include in Looker.
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.
❤
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.
Thank you!!! I can now stop banging my head against my computer screen. 😉
Thank you. Explained well and at the right speed
great video, thanks for sharing!