How convert or unstack one column of data into multiple columns using the Index and Sequence functions in Excel 365 under 5 seconds.

Watch the video below:

More about the SEQUENCE function:

• Available in Excel 365
• Using the SEQUENCE function we can generate a list of sequential numbers in an array
• In a worksheet cell if we write =SEQUENCE(3,4) then we will generate an array that consists of 3 rows and 4 columns as shown in the image below

To create a random list of numbers in 5 rows and 6 columns we can use the following nested SEQUENCE function: =SEQUENCE(5,6,INT(RAND()100),INT(RAND()100))