Vertical to horizontal one column and underneath

[vinaynaran]

Please see attached file.

I have two columns “Branch” & “Part” in Data sheet.

It look like below

Branch Parts
2 401442511
2 401590491
2 401660461
2 401680181
5 401221001
5 401680211
7 402590682
8 401440292
8 401442511
8 401660391
10 401330101
10 401745751
11 401110762
11 401750962
11 401860061
11 657444130
14 402590782

I want to display Branch in horizontal and part underneath in to it like below

2 5 7 8 10 11 14
401442511 401221001 402590682 401440292 401330101 401110762 402590782
401590491 401680211 401442511 401745751 401750962
401660461 401660391 401860061
401680181 657444130



Please help me if you have any formula or macro to do automatically.

Regards
Vinay