combine two rows

[mtdew]

My data has most of the information on one row (MLS#,Ar,S,Address,BR,Bth,YrBlt,Price,DOM,Ofc Phone). The second row contains two fields which are merged into one cell, B2 (Example: SP: $6,100 SD: 11/02/2004).

To be able to total up the SP or graph with the SD data I need all the information on the same row and the SP and SD in seperate columns. I've successfully created a formula that allows me to pull the SP data

(=IF(H2>9999999,MID(B3,FIND("$",B3,1),10),IF(H2>999999,MID(B3,FIND("$",B3,1),9),IF(H2>99999,MID(B3,FIND("$",B3,1),8),IF(H2>9999,MID(B3,FIND("$",B3,1),7),IF(H2>999,MID(B3,FIND("$",B3,1),6))))))

but I'm not able to delete the second row containing the SP & SD data and retain the data on the first row so therefore I'm not able to total the columns. I thought about sending every other row to another sheet. Is that the best way to handle it?

 

[SkipVought]

Hi,

Use the formula to populate the main row.

Sort the entire table on a column containing an empth cell in the non-main row.

Delete the unused CONTGUOUS rows.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}