So I have a bunch of raw data that is basically categorized into three categories (ignore three constraint, let’s just say n categories). I want to split this into multiple columns where each column is its own category. Example:
Data:
Type Value
1 5
3 6
1 2
2 8
2 4
3 5
2 3
Output desired in a new location on the spreadsheet:
1 2 3
-----------------
5 8 6
2 4 5
3
I have looked at Pivot tables but don’t exactly understand how to accomplish it using that. So, I would appreciate help in either understanding the Pivot tables approach, or some other approach.
I looked at other posts, and couldn’t find anything that exactly matched this requirement, so please don’t flag duplicate. Also, I want to avoid using VBA as this is part of a statistics project.
