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

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
 
J

Jacob Skaria

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

Publisher is filling blank lines with data 2
Dealing with a Pivot Table (when I don't want to) 0
Auto populate value from one task to another in MS PROJECT 0
how to copy and paste value from one sheet to another 4
GETPIVOTDATA and (blank) 0
Lookup whole sheet and add datas from specified date to end date 0
Copy Data from 1 Sheet to Another 3
Copy and paste slide from one presentation to another presentation gives an error 2

Top