Deleting Rows Between Empty Cells
Thanks.
"Duke Carey" wrote:
Best to sort the data to put all the blank rows at the top of the bottom,
then delete them. Alternatively, go to Access and use a query to delete the
blank rows before you copy the data.
"Daren" wrote:
I have a large data set that I'm copying from Access into Excel. There are
blank rows between the data I want to analyze. Is there a way to quickly
delete these rows so I can have the date inn consecutive rows? Thanks.
|