Скачать или смотреть New 2023 Google Sheets functions to transform, clean, and organize your data - Tutorial

Google Sheets released some new functions in 2023 that help you transform, clean, and organize your data. Some of these functions are simple to use and other ones are a bit harder to understand. In general, they help the beginner spreadsheet user better organize their datasets so that the spreadsheet is easier to read.

EPOCHTODATE (convert unix time stamp to date/time) - 0:00
TOROW/TOCOL (Arrange a bunch of cells into a single row or column) - 1:27
CHOOSEROWS/CHOOSECOLS (Choose which rows or columns you want from a data set) - 3:35
WRAPROWS/WRAPCOLS (Turn a bunch of cells into a specified number of rows or columns) - 6:40
VSTACK/HSTACK (Stack rows from different sheets on top of each other) -10:20
LET (Assign the result of a formula to a variable to use in the future) -13:36

👉 Intro to Excel class: https://skl.sh/3Ctmjq9
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 TikTok:   / dear.analyst  
👉 Instagram:   / dear.analyst  
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy...