Fixing improperly entered data

does it really look like that ???
so a row with just the name in
followed by a row blank

and the row you want the name to be in - has entries in column A and C

if so
insert a column in A

Assuming row 1 - is a header row and the data starts in row 2

use
=IF(AND(B2<>"",D2<>""),B3,"")

then you can copy down the sheet
When complete
next - click on column A
copy >
Paste Special > Value
now you can sort by column A
and delete all the rows with Just the names in column B

Can you tell the cell from where your data starts i.e. the very first value of your data....like IBM in your example

Hi mike and welcome to the forum.

A simple formula in Column D and then Copy and Paste (Values Only) and sort by date and delete those non date rows should do you.
Make a copy of your data on a second sheet before working with your real data. Make sure the spacing is correct for all pairs first.

See the attached for the example.

You could try something like this:
Enter this formula in E2 (assuming that your data starts in A2) fill across to column H and fill down. When finished select all the new data, copy and paste VALUES. Now you can sort the data.

Formula:

Please Login or Register  to view this content.

Result:

	A	B	C	D	E	F	G	H
2	IBM	01/01/2015	10		IBM	42005	10	Dave
3	Dave
4	Google	02/01/2015	8		Google	42006	8	Mike
5	Mike
6	Apple	03/01/2015	20		Apple	42007	20	John
7	John

Result after sort:

	E	F	G	H
2
3
4	IBM	42005	10	Dave
5	Apple	42007	20	John
6	Google	42006	8	Mike

Delete blank rows.

Another formula:
=IF(COUNTA(A2:C2)=3,A3,"")
And then copy paste specials values and sort.

What is the EXACT form of your raw data?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic