Transpose multirows from two column into single row with one header

Hello All,

Hope you have a great time.

I am trying to transpose data in multi rows from two column into single rows with one header.
Attached is the macro mockup, need small adjustment, because it's only transpose first column.

Please Login or Register  to view this content.

Thank you.

maybe so

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

yes it work, it just don't copy the header.
but i think i can use it
Thank you for your help.