Forum Discussion
Copy Paste
Hi want to copy rows as in the attached files.
Just want to copy contents of first three columns in next row. I want to automate as there are more than 30k rows. Copy, paste will not work.
First 3 columns or first 3 rows?
Perhaps you mean to copy with removing empty rows? When why 2 appears in destination second row?
- Yes, this way. first three rows.
Same for 4-5, 6-7 and so on.
please suggest excel formulas or macroIf manually you may apply filter to your range, deselect blank cells, copy result and paste it onto new place.