need vba code to copy set of data in row to column

[johnlara]

Dear experts

I have set of data in sheet rawdata which is in row down as set of data need to copy column in separate header value

please find the attachment

[jindon]

Please Login or Register  to view this content.

[mohadin]

Hi

Please Login or Register  to view this content.

[johnlara]

WorKs Amazing but small END WITH "error 9 subscript out of range"

[johnlara]

Thanks for perfect code which is works amazing one thing which is not copy data till end of row where it ends of data

please find real data in xls

[jindon]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[johnlara]

Thanks it works perfectly