How To Pivot & Unpivot Tables In Google Sheets

Before the discovery of a hidden function a couple years ago, unpivotting data was a pain in the neck! Let's see how things have improved thanks to a quick mixture of FLATTEN and SPLIT. ---------------------------------------------------------------------------------------------------- ⏳ TIMESTAMPS ---------------------------------------------------------------------------------------------------- 0:00 Unpivotting data 3:45 Pivot your data with QUERY 6:05 Using Pivot Tables ---------------------------------------------------------------------------------------------------- 💬 GOT A QUESTION? ↓↓↓ Leave a comment down below ↓↓↓