Please advise with this:

A1: 1
A2: 2
A3: 3
A4: 1
A5: 2
A6: 7
A7: 1
etc..

B1: 5K
B2: 2K
B3: 3.7K
B4: 4K
B5: 2K
B6: 4.5K
B7: 110K
etc....


I need to transpose values from column B to column C.

If A1: 1 I need to take value from B:1 and place it in C1. If number 1 repeats in Column A (A5), than I need to paste value of B (B5) to D1 etc....

So in above example, I would have:

C1: 5K, D1: 4K, E1: 110K etc...


Please help!

Thanks a lot!