Function to move data

  • Thread starter Thread starter ManhattanRebel
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Sorting and Formulas 1
How to move data from rows to columns 6
Excel Moving data to sheet2 from sheet1 0
Summing cells based on mulitiple criteria over mulitple columns 1
"Find Most Opposite" Function? 1
Appending Data from one spreadsheet to another 4
How can I move data from a row range to a column range 4

Back
Top