Unpivot Data using Google Sheets

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
- - - - Blog - - - -
www.goodly.co....

[@dadsinvestmentfundsdif6215]

Bro.... 3 weeks of my life wasted... looking for an answer to this....
This should be up there with the answer to the meaning of life.
You're a life saver.... Love you bro.
I've Subscribed :)

[@GoodlyChandeep]

Being next to the meaning of life is a big compliment.
Thanks Bro.. glad I could help :)

[@luizapcmoura21]

I wasted a day of work to find a explanation like this!!! You are amazing!! Thank you!!!!!

[@santsangwornrachasup6613]

Great vid and demonstration. Short and straight to the point. Thank you!!!

[@jehanr]

WOW = this is awesome - been trying to figure this out for ages!!!!

[@meihongwong-6530]

omg life saver! spending whole day to look for how to do this and glad I found this term unpivot and your explanation!

[@bharathau8085]

A BIG THANKS.. WAS LOOKING FOR THIS FROM LONG TIME !!

[@patrickmc8779]

Thank you for this. This is a fight between working on the cloud with google sheets and having better interfaces with Excel. Makes it harder to streamline the workflow of a company.

[@muhammadnurhakimmohdderis4201]

Wow... SubhanAllah... great solution being searching in the past 2 years already since I'm a heavy user of google sheet..

[@alevillalobos676]

Muchas muchas gracias!!! te amo!!! Horas de trabajo ahorradas!
Thank you soooo much, you save me hundreds of hours

[@muhammadfitra1132]

this one the best tutorial really saves the day

[@GoodlyChandeep]

Glad it was helpful!

[@neerajsrivastav5082]

This is really Super helpful!!!

[@wayneedmondson1065]

Hi Chandeep. Excellent! Thanks for showing this technique in Google Sheets. Was not aware of the FLATTEN function. Very cool. Microsoft should take note. Thanks for sharing your knowledge. Thumbs up!!

[@GoodlyChandeep]

Glad you liked it Wayne!
Power Query is perhaps Microsoft answer to everything good in Google Sheets! :D

[@jeremy_ching]

saved a lot of my time, thanks goodly

[@GoodlyChandeep]

Glad it was helpful!

[@chakralamurali]

This is marvelous

[@przemysawknitter2811]

Man! Thank you so much for this!

[@O.MartinsLucas]

Show!
You're so smart man, thanks for the video!🇧🇷

[@GoodlyChandeep]

Thanks Aleatoriamente!

[@mitchkehlet3638]

this was incredibly helpful and saved me a ton of time. thank you!!!

[@elianasuarez3755]

Great simply explanation! Super helpful tool!

[@necuo25]

Really really glad to watch this, it's 2am in the morning and so glad about your video.
Life saver for certain

[@GoodlyChandeep]

Welcome aboard!

[@chakavak55]

Very clever, thanks

[@Drengen10]

Any tip to have blank entries not show up as a row? Let's say Roy had a blank value on 9th of January. I would still like the rest of the 9th of january
Second issue is having a change range end. How do i prevent it from using blank rows that would have data in the future?

[@user-em1fo8dl9y]

Thank you

[@briandegregory3627]

Great video and awesome! Thanks! Would there be anyway to add a filter to remove all blank value as well?

[@irvingsamur3675]

Maravilloso!

[@GoodlyChandeep]

Thanks

[@sj3309]

Really helpful

[@GoodlyChandeep]

Glad it was helpful

[@jasonbryll8922]

If I want to Unpivot Google Forms results, can I make the bottom of the range dynamic?
Also, can I have the unpivoted table version auto populate with new results as more forms are completed?
My questions appear as columns, where I want them as rows. My questions in this case are scores (Yes = 1 NO = 0 N/A = null), and I need to pivot on the data.

[@ingeborgalternvedal802]

Very useful, thank you!

[@learnspreadsheets]

This is BRILLIANT! I have been looking it for years, I can’t seem to get it to work though with certain text columns not being unpivoted (eg col names are name, place, product, JAN, FEB, MAR, APR, comments), I only want to unpivot the columns in CAPS, Any suggestions?

[@GoodlyChandeep]

Thanks David.
Glad to see you here.
To make this work you'll first have to make a concatenated column with Name, Place, Product so that you have the following columns
Concat, Jan, Feb, Mar, Apr
and then proceed with flatten function!
Hope this helps :)

[@GoodlyChandeep]

In the flatten function mention
Rows in concat column
Column = Jan, Feb Mar,
Values = Cross tabulated values
It should work

[@learnspreadsheets]

@@GoodlyChandeep yes that’s what I thought, wonder if it’s doable in one formula! May experiment soon

[@learnspreadsheets]

Also feel free to check out my own RUclips, I have many videos on g sheets too!

[@44.7b.kaharaditya6]

Superb Sir 👍

[@NagaRajuvenkatapuram]

Super cool idea !!

[@puthdarakim1175]

Dear Sir,

[@victoriawilson6135]

Love this, are you planning to do one that involves multiple headers in google sheets?

[@GoodlyChandeep]

Google sheets makes unpivoting difficult with double headers. Although a quick hack is to concatenate headers to form a single header and then carry out the process.

[@sideshowbobby71]

Great job!!!

[@chutkiandsaharsh3435]

Thank you soooooooooooooo much bro

[@GoodlyChandeep]

Pleasure! 💚

[@juanfox2657]

Genius

[@GoodlyChandeep]

Thanks!