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.

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

[Aman_Tiwari]

Please upload a video for the Same problem but this time have multiple line items under one head
Eg. Fruit name
Price
Sales rep
Location
Branch 1, 2, 3, etc
And so on