Скачать с ютуб Excel Pro Tricks: Dynamic Excel Formula to Restructure Excel data with TEXTSPLIT & TEXTJOIN Function в хорошем качестве

Excel Pro Tricks: Dynamic Excel Formula to Restructure Excel data with TEXTSPLIT & TEXTJOIN Function

Learn how to restructure or reshape Excel data or array using dynamic array formulas using simple to understand Excel functions without the need of power query, copy/pasting or manually typing the data. In this Excel tutorial, we learn how to reshape, remodel or restructure Excel data using combination of TEXTJOIN and TEXTSPLIT function to split delimited data in one column to multiple column all using a single dynamic array formula in Excel. Best thing about this approach is that output is dynamic that is output updates itself automatically every time source data changes. Special thanks to Aditya Kumar Darak for the help and input in this example. His idea of using multiple delimiters in TEXTJOIN function made me realize that the last delimiter given in the string is used to append multiple rows of array which can later be used to split down the rows using TEXTSPLIT function. You can reach out to him on his linkedin profile here:   / acoaadecv4mbiyyf69rzpc6m_otxnslsbqwar44   Lets Excel! Access or Download Practice workbook for this Excel tutorial: https://1drv.ms/x/s!Apno7889bCyLkGQXP... For more Excel tips, tricks and tutorials don't forget to subscribe to ‪@LearnExceltoexcel‬ YT channel. Learn #Excel your way: =================== Website: https://learnexceltoexcel.com/ -------------------------------------- Pick your favourite social page: Fb: https://bit.ly/3yM3dvd Tiktok: https://bit.ly/3wFllpf Tw: https://bit.ly/3wGCRYU Pin: https://bit.ly/3NsjKIU Yt: https://bit.ly/3wxKL8a Insta: https://bit.ly/3wtT9oW Music by:    / ikson   #excel #exceltips #exceltricks #exceltutorial #exceltutorialforbeginners #excelformula #excelfunctions #excelformulasandfunctions #excelformulatypes #exceltable #exceldata #data #dataentry #dataentryjobs #dataentryspecialist #textsplit #textjoin #datarestructure #datamodeling #datamodel