Function to move data

M

ManhattanRebel

I have too much data to sort, cut and paste. Is there a function I can use in
a formula to move data from one column to another? For instance, I need to
move “red†from Column B Row 2 to Column Z Row 2 and “blue†from Column A Row
2 to Column X Row 2 and so on.
 
D

Dennis Tucker

Entire columns can be selected and moved to other positions. Just select
the column you want to move by clicking on the column heading(A, B, C, . .
..) then click-hold-drag the right or left edge of the selected column to the
new position.

Dennis
 
Top