View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dennis Tucker Dennis Tucker is offline
external usenet poster
 
Posts: 140
Default 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.