Hi All,
Please see the below example. Is there a way I can select the data in col. B and either cut / paste or drag over into col. A without overwriting the existing data in Col. A? So as to essentially just fill the gaps.
Dragging the Col. B items over one at a time will be rather time consuming for the list I have on my actual sheet.
<tbody>
</tbody>
Thanks for the help!
Cheers,
Dan.
Please see the below example. Is there a way I can select the data in col. B and either cut / paste or drag over into col. A without overwriting the existing data in Col. A? So as to essentially just fill the gaps.
Dragging the Col. B items over one at a time will be rather time consuming for the list I have on my actual sheet.
A | B |
Colour | |
Blue | |
Red | |
Green | |
Yellow | |
Brown | |
Purple | |
Silver | |
Orange | |
Pink |
<tbody>
</tbody>
Thanks for the help!
Cheers,
Dan.