Sunday 15 February 2015

Shift information into one column in Excel -


I have an excel sheet with information in the cells scattered.

Do you know about an efficient method, repeat all the cells with the information so that each cell is now in the first column (the sequence does not make any difference)?

If there is not too much data, select all cells, F5, 'special ... Press' Select 'Blank', then delete cells and make changes on the left.

No comments:

Post a Comment