SEQUENCE, VSTACK, INDEX, COUNTA - Split Info From 1 Column Into 2
Today I want to show you how to dynamically split information from 1 column into 2, using Excel Functions.
In my previous video I showed you how to do this using Power Query:
• Split information from 1 column into 2 wit...
In this tutorial we're going to use =SEQUENCE( ), =INDEX( ), =COUNTA( ), and =VSTACK( ).
Do you want to learn more about =VSTACK( )? Here you can find more information about it:
• Append tables with VSTACK and Power Query ...
Hope you find this information useful.
Thanks for watching. 😊
You can find the working file here:
https://drive.google.com/drive/folder...
#MSExcel #ExcelFunctions #Sequence #Index #VStack #CountA #AlejandraHorvath #MakeYourLifeEasier #Empowered2XL