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

Deleting parts of rows to combine data into one row
Compare two Excel sheets: and combine data - Guide
How to combine data from multiple sheets - Guide
Delete or insert rows in a workbook ✓ - Forum - Excel
Excel vba delete all table rows except first ✓ - Forum - Excel
Deleting and combining rows in excel with con ✓ - Forum - Excel

Subscribe To Our Newsletter!