Deleting parts of rows to combine data into one row

Closed
kirkross - Mar 28, 2017 at 05:22 PM
Hello,

I am using excel 2010. I have a very large data set where I need to delete cells AI4 to BC4, A3 to AO3 and A2 to AH2 then AP2 to BC2. This will combine segments of 3 rows into one row. I then need this macro to repeat on row 3 and so on down the spreadsheet until the end of my data. Can anyone help?

Thanks