Hi,

Since you don't show us what your data looks like its all guesswork:

Suppose that Name is in column A but only on the first row of data for John
Jones, while the next two lines under name are blank but his data.

1. Select all the cells in the Name column down to the bottom of your data.
2. Press F5, Special, Blanks
3. Type =, up arrow, Ctrl+Enter (I'm using commas to separate the
commands, up arrow is done from the keyboard)
This fills in all the missing names. Select the all the entries in the name
column and Copy, then choose Edit, Paste Special, Values.

If this doesn't work we need to know the data layout.

--
Thanks,
Shane Devenshire


"DaveK" wrote:

I have input a bunch of data that is a name followed by other information.
The other information is contained over more than one row, address etc. I
need to sort this info by different columns so I would like to make it a
table but when I do each row is a different row in the table the result being
that when i sort I lose half of my info.
Suggestions please, thank you.