0

I have an Excel Sheet with information in scattered cells.

Do you know of an efficient method to reposition all cells with information so that each cell is now in the first column (order does not matter)?

  • This might help: http://stackoverflow.com/questions/4480227/how-to-consolidate-data-from-multiple-excel-columns-all-into-one-column – Jack Jun 21 '13 at 13:01
  • 1
    Depending on within how many columns the information is scattered. If it's not that many, after the last column, concatenate all the columns, then cut the column and paste in column A as values. You can then delete everything else. – Abe Gold Jun 21 '13 at 13:18

1 Answers1

0

if there isn't too much data select all the cells, f5, press 'Special...', choose 'Blanks' then delete cells and choose to shift left.

JosieP
  • 3,360
  • 1
  • 13
  • 16