Forum Discussion
Solved
Filtered List - Cant Copy from one column to another
Hello Experts, I have had this issue of not being able to copy data from one column to another if the list is filtered. I want to be able to copy the entire range and paste it into the same rows in t...
ahh yes the flash fill. Awesome. Thank you very much.
- You're welcome! The only drawback to using Flash Fill is the columns have to be neighboring each other. In your example it works out.
HI Patrick, I am having a tough time making it work. My columns are next to eachother in the attached but I still cant get flash fill to work. Do you happen to see why?
In my real data set the columns are actually not next to eachother. Do you know of a work around? I could put the columns next to each other I guess since it would still be better than manually copying and pasting one by one.
thank you
Please see attached
