Macro to transpose unstructured data

[Chouz06]

Hi All,

So i have been sent unstructured data which i need in a nice format to analyse. I have attached what i would like the data to look like (the part at the bottom of the image).

I dont know if there is any code which would help in getting my data to look in that format. Appreciate any help

Thank you!

 

[CJ_London]

to clarify - is this an excel or an access question?

If excel, have you looked at using the transpose or pivot functionality

Transpose (rotate) data from rows to columns or vice versa - Microsoft Support

How to use Transpose in Excel to rotate columns and rows to rearrange your worksheet data.

support.microsoft.com

For access, data should be stored per your bottom table, not the top one. To convert, consider using a union query