Grouping raw data into columns of data Excel

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.