I have coded a VBA macro to process downloaded data. The data has some junk rows that need to be deleted, but also has some rows where the data is off by a couple of columns and a couple of rows. The macro moves data to the right place and deletes unnecessary rows.

Need a macro that will help me process data where they add an X to mark which group the row belongs to. For example:

Need a macro that will help me process data where they add an X to mark which group the row belongs to. For example: