Hi,

So i have data that gets seperated into different cells and what i need is for all the data to line up from left to right with no empty cells in between.. so basically shift delete on each cell and shift the data left.

So i thought i know, ill simply f5, select the blanks, delete and shift left... however that option doesnt come up.. it simple says delete row?

What is the best way to select all the blanks in a range and delete them and have the cells that contain data move to the left so all data is next to each other.


Hope this makes sense!