Formula to transpose data

[WynH2017]

Sorry, first post so forgive me if I get anything wrong.

I am a fairly experienced excel user and happy to use any formula for my requirements I'm using 64 bit Excel 2016.

My issue is trying to transpose large amounts of data using a formula (vlookup/hlookup/index match are in my mind but not enough to make it work)

What I have:
A B C D
123 xxx ccc hhh
456 yyy ddd iii
456 zzz eee jjj
456 aaa fff kkk
789 bbb ggg lll

What I want:
A B1 B2 B3 C1 C2 C3 D1 D2 D3
123 xxx ccc hhh
456 yyy zzz aaa ddd eee fff iii jjj kkk
789 bbb ggg lll

But I have 5000 rows of data and B1-B3 etc would go as far as 50 extra columns

Any help would be much appreciated.

 

[Jborg]

Yes Formula starts in C12. Sorry for the mix-up.

 

[Peter_SSs]

Yes Formula starts in C12. Sorry for the mix-up.

No problem John.
Have you now been able to see the layout in post 1?

 

[Jborg]

Yes. I did. Thanks