If you've ever tried to copy data from one column in a filtered list, to another column, you've discovered that Excel didn't keep all your data on the same row. See below
![upload_2014-6-13_13-40-30.png upload_2014-6-13_13-40-30.png](https://chandoo.org/forum/data/attachments/7/7579-e0ed75288c9929ef2eff4a9720050326.jpg)
Ugh, it put all the data together, with the 37 value going into one of the rows that's currently hidden. That's no good!![Frown :( :(](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
However, there is a workaround. Select the two columns (if columns are not adjacent, you can hold Ctrl down to select separate ranges). Select only the visible cells (Ctrl+g, Special, Visible only).
Now you're ready for the magic!
Check out these commands on Home ribbon, hiding on the right side
![upload_2014-6-13_13-42-42.png upload_2014-6-13_13-42-42.png](https://chandoo.org/forum/data/attachments/7/7580-d765f8e48ea64cf6ffb925168f7f3cb9.jpg)
Instead of trying to do copy and paste, we're going to "fill left" from the Debit column to Credit column. Voila!
![upload_2014-6-13_13-44-0.png upload_2014-6-13_13-44-0.png](https://chandoo.org/forum/data/attachments/7/7581-6f0a8c67058752bf89b91a463b3fd3f8.jpg)
You could, of course, use the Fill left or Fill right, depending on which way you need the data to go. Anyway, that's my new trick that I learned this week, hope it helps someone else on their way to being awesome w/ Excel.![Awesome :awesome: :awesome:](http://cache.chandoo.org/images/bg/logo-smilie.png)
![upload_2014-6-13_13-40-30.png upload_2014-6-13_13-40-30.png](https://chandoo.org/forum/data/attachments/7/7579-e0ed75288c9929ef2eff4a9720050326.jpg)
Ugh, it put all the data together, with the 37 value going into one of the rows that's currently hidden. That's no good!
However, there is a workaround. Select the two columns (if columns are not adjacent, you can hold Ctrl down to select separate ranges). Select only the visible cells (Ctrl+g, Special, Visible only).
Now you're ready for the magic!
![upload_2014-6-13_13-42-42.png upload_2014-6-13_13-42-42.png](https://chandoo.org/forum/data/attachments/7/7580-d765f8e48ea64cf6ffb925168f7f3cb9.jpg)
Instead of trying to do copy and paste, we're going to "fill left" from the Debit column to Credit column. Voila!
![upload_2014-6-13_13-44-0.png upload_2014-6-13_13-44-0.png](https://chandoo.org/forum/data/attachments/7/7581-6f0a8c67058752bf89b91a463b3fd3f8.jpg)
You could, of course, use the Fill left or Fill right, depending on which way you need the data to go. Anyway, that's my new trick that I learned this week, hope it helps someone else on their way to being awesome w/ Excel.
![Awesome :awesome: :awesome:](http://cache.chandoo.org/images/bg/logo-smilie.png)
Last edited: