I presume you are trying to ask something more difficult than "how do I
return the values in the first row of a range?", but if so, then the basis
upon which your desired result is to be returned is unclear. More
information, please.

Jerry

"raiders1" wrote:

I have data that I have brought into a spreadsheet from our manufacturing
database.
I have cells that have doubled in the query I did. Example below:

Item No Order Qty CO# lIne# Mfg Or Machine Raw
Material Yield

524725 25,000 52 2 22546 Compo
1755012546 500.00
524725 25,000 52 2 22546 Compo
ikraft 250.00
524725 25,000 52 2 22546 Sub
1755012546 500.00
524725 25,000 52 2 22546 Sub
ikraft 250.00

I was wondering if there is a formula that I can use to get this result

524725 25,000 52 2 22546 Compo
1755012546 500

ikraft 250

Sub

Thanks!!