I have a simple spreadsheet that has a large volume of data structured as such;
A1 B2 A3 B4
- Going down several thousand rows.
I'd like to move all of column B into the blank cells of column A, keeping the same rows, so the data would become;
A1 A2 A3 A4
Is there a simple way of doing this? When moving the data it overwrites everything in column A