transpost column data into rows using array only

[BS Singh]

Hello Experts,

I am new to VBA and trying to learn VBA Array.

Could somebody please help me to solve my attached problem.


So far I am using below code however this is giving me the output of first record in all three rows. I would like to have dynamic range so that if we add more records then same code can be applied.

Please Login or Register  to view this content.

Thanks for your help.

Regards,

[AB33]

The code assumes that the format remains consistent

[patel45]

Please Login or Register  to view this content.