Prolific Oaktree's video: Google Sheets - Unstack a Column of Data into Multiple Columns - Two Methods

Learn how to unstack data that is only in one column into a table with a column for each value type. We will explore two different methods. One is a bit of a "hack" while to other uses a somewhat involved formula. Choose the one that works best for you. Formula in column G =FILTER(A1:A, MOD(ROW(A1:A)+2,3)=0) Formula in column H =FILTER(A1:A, MOD(ROW(A1:A)+1,3)=0) Formula in column I =FILTER(A1:A, MOD(ROW(A1:A),3)=0) 🕒 Timestamps - 0:00 - Intro - 0:43 - Try it manually - 2:02 - First method (filler text) - 3:26 - Second method (formula) Learn more from Prolific Oaktree: 🎓Master the Fundamentals of Google Sheets - http://bit.ly/PO-Basics 🌳 Next Video - Google Sheets | Sort and Filter by Color https://youtu.be/7VgpDfLlKmc 🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/google-tutorials