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.


excel move data from one column to multiple columns,easy data unstack excel,stack columns of data excel,
how to combine clustered and stacked column in excel,how to create 2 stacked columns in excel,how to combine two stacked bar charts in excel,excel stacked column not stacking,

#excel #tips #shorts #fyp