This is just the way I have to deal with it. Column A & C will never have the same info on the same row of course.
The ugly workaround I Have been using is to make another extremely long column which basically stacks the Column A & C on top of each other, but that takes thousands of rows to do...
I am trying to find an elegant way to do the following:
My data currently looks like the following.
---------Column A----Column B----Column C----Column D
Row1-----Apple---------7----------Peach---------5
Row2-----Peach---------10---------Apple---------6...