Split and Flatten Functions - Google Sheets
Today I am going to show you two very cool formulas in Google Sheet: SPLIT and FLATTEN.
Hope you like them and find them useful in your day to day work 😊
0:00 Intro
0:17 Data Overview
0:45 The SPLIT Function
2:08 Adding The ARRAYFORMULA To The SPLIT function
3:16 The FLATTEN function
6:49 Tip To Avoid Blank Cells On The List: The FILTER Function
8:19 Wrap Up
#GoogleSheets