vba code to adjust scattered data in their respective columns

Hi All

I have an export sheet from an interface but the data and columns are scattered .

Columns A have data that needs to be split in their respective columns , the data needs to be adjusted in their respective columns and totals to be added at end of respective columns.

Page numbers need to be repeated which is added at end of each page report number .

However the format is always the same as no of pages reads to 200 pages or more .

Looking for code that can insert , adjust data.

Thanks if someone can assist