how can i transfer data from one sheet to another without blank li

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear All

I have extracted data from a system to a sheet including blank lines between
the data.
Any idea of how i can transfer the data from one sheet to another without
any blank lines, in order to do my job using excel functions?

Thanks in advance
 
If you mean blank rows why dont you just sort the data?

In case you need to retain the order (you can use a temporary column);
insert an additional column say A. Number 1,2,....till the end in cells a1,a2
...... Sort col B. Delete the blank rows..and then sort by ColA...Remove ColA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA and (blank) 0
How can I find data in one list and add it to another sheet? 2
Copy Data from 1 Sheet to Another 3
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. 1
COUNT rows on external sheet if between date range 3
Transfer certain data from Sheet 1 to sheet 2 6
Blank cell from another page within a worksheet? 9
transfer data from sheet1 to sheet 2 5

Back
Top