Need Macro to clean and organize the data

[ABC User]

Hi,

I am new to VBA and would like to understand the starting point or macro that I can apply to clean and organize data. The data received is not in the same order and format every time but the output or reporting has a set format that needs to be used. What macro can I apply to be able to sort and organize the data to achieve the output or reporting?

Any guidance or help will be much appreciated.

 

[AlanSidman]

VBA is not generic. You will need to supply a sample workbook and a mocked up solution for a workbook specific solution. No pictures. Upload your sample file of 15-20 records.