Every 2nd Thursday our team has to produce reports from data provided to us in a Excel spreadsheet. Typically this data has about 23,000 rows of data. The problem is that since June these spreadsheets now have duplicated rows, due to a problem in the data warehouse they’re produced in.
I don’t understand anything about that side of thing, but what I do know is that we need to find an easy way to delete every second row. At present we are splitting the data into 3 spreadsheets and I have 3 staff members deleting every 2nd row in their respective spreadsheet. When they’re all finished we merge them back into one spreadsheet to produce our reports. This is a big time waster (it still takes hours to do), creates a lot of stress due to other work getting delayed, and ruins morale in the team.
We’re using Excel 2011 on iMacs running El Capitan, so I was thinking that a macro could do this, right? Can someone confirm if this is the case and if yes how we would go about it?