Hi have a large amount of information in column A. Every row of data is separated by 6 blank rows. Including the 6 blank rows it’s a total of 34897 rows!! I need to delete all the blank rows in-between therefore moving all the data up. I’m using the ‘go to special – blanks selection. And then once selected I use the ‘delete sheet rows’. This works okay if I choose a small number of rows at a time, although it is slow. However if I choose a large number of rows I get a ‘not responding’ message. I’ve removed all formatting and formulas thinking that may be affecting the process but this didn’t make any difference. Am I doing something wrong? Is there a way to get the job done efficiently? I have a number of sheets to do and this will take a lifetime the way I’m going