FLATTEN in Google Sheets: Combine Multiple Columns into One (3 Examples)

0:00 - Sales table example
1:45 - Country data example
3:01 - Student names example
In this video, I go over three examples to show you how to use the FLATTEN() function in Google Sheets. The FLATTEN() function helps you transform tabular data or combine data from different columns into a single list.

[@CaribouDataScience]

Flatten = unpivot?

[@MedianPulse]

@@CaribouDataScience yes! "unpivoting" is definitely one of the key use cases of the function