Macro transpose data one column to multiple column & row

[Jhon Mustofa]

hi expert..

i need some macro code to transpose data in one column to multiple column & row..

please, see workbook attached..

any assistance would be greatly appreciated...

john m

[GC Excel]

Hi,
Here's a proposal (adapt as required). Not sure if you needed to keep empty rows between each name...

Please Login or Register  to view this content.

[Jhon Mustofa]

hi GC Excel, very excellent!!

thank you very much...