I have been trying to use pivot tables, sort and filter and no luck. The data that I have is a the following:

Number Level
234 12
456 13
456 14
7855 11
352 15
342 18
342 21
342 50

And, I want the data to look like the following:

Number Level Level Level
234 12
456 13 14
7855 11
352 15
342 18 21 50

Is there a macro or formula that can apply to the entire document? The entire document is 10000 rows of data but there are only 15 different levels. Thank you.