Unstack Data from one Column to Multiple Columns - Clean Up Mixed Case Text - Excel Tips and Tricks

Learn how to unstack data from one column to multiple columns.

Here are the steps.

Populate Data
1) Select the whole stacked dataset.
2) Ctrl + C
3) Select first cell in next column
4) Ctrl + V
5) Select first cell in column
6) Ctrl + - (minus)
7) Shift cell up
8) OK

Filtering & Remove Rows
9) Data --- Filter
10) Filter first column "Sort Z to A"
11) Delete rows of data that is not suppose to be in the column.

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ