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