How to delete empty wells?

[Jamie1982]

Hi,
I've had to import data from a text file, that has imported in the following format (with each dot representing an empty well):
A1.x..y
A2.x....y
A3.x......y
A4.x........y

etc etc.

I have many of these files, going down 100 wells each, each with a value for x and y. Each y value is one cell down and two across from the previous ones. This rapidly gets silly (the last y value is in column GT!) when trying to manually delete the empty wells so that x and y end up next to each other. In my old version of excel, I would have bitten the bullet and recorded a macro doing it for one sheet so i could then just apply the macro to all the other sheets that are in an identical format. However, Microsoft decided that recording your own macros wouldn't be allowed in 2008 , so I can't.

Can anyone help me with some advice for how to delete the empty wells from the sheet?

Thanks in advance
J

[martindwilson]

what was the delimiter when you imported it?

[JBeaucaire]

Try this after the import is done:

1) Highlight all the data
2) Press F5 (or Ctrl-G) and select Special > Blanks > OK
3) Select Edit > Delete > Shift Cells Left > OK