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

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

Please Login or Register  to view this content.

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

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

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks it works perfectly