Function to move data
 

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.

Function to move data
 

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

"ManhattanRebel" wrote in message
...
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.