Copying visible cells only into new column

[kbccc]

Hello,

I have filtered my data so that only the cells that I want are visible and have selected visible cells only. I removed my filters and I would like to copy and paste the cells into another column but when I copy them over, they are compressed and not actually lining up with the correct row after the filters are off. I would like there to be blank rows between the copied cells to match where the cells are without the filters on.

Thanks

 

[Marc L]

Hi,​

​

not very clear but as you can copy consecutive cells at a time in order to 'line up with the correct row' …​