OK, so that would identify each row as to what item it belongs to, but how
would I concatenate from here? I need a formula that would identify each
group to concatenate to a single cell for each item. Thank you.

Snakeoids.

"CLR" wrote:

I would use the free add-in called ASAP Utilities, available at
www.asap-utilities to fill in all the items numbers with the one above, if
they are blank, then in C1 put something like =IF(A2=A1,B2,"") and copy
down.......in D1 put =IF(A3=a1,B3,"") and copy down, etc etc for as many
columns as you have the max number of rows of description. This will
eventually give you one row of all the descriptions for the first item in
each series.........then you can CONCATENATE at will....

hth
Vaya con Dios,
Chuck, CABGx3





"Snakeoids" wrote:

Greetings,
I have a large list of item (literally thousands) in Excel. In a given row,
there is an item and fields of info (size, type, description, etc).

However the Description field is not restricted to just one row like the
other fields are. This is a problem for me. So I want to compile the data
in adjacent cells into one cell. Normally I could do this with a
"concatenate" function, but the problem is that there's no consistency to how
many adjacent cells to a given item description. For exampe:

Part Desc.
Item 1 Description 1
Item 2 Description 2
Description 2 con't
Description 2 con't
Item 3 Description 3
Item 4 Description 4
Description 4 con't
Item 5 Description 5

Maybe one way to "trap" the group of descriptions to a given item is by the
blank rows between Item numbers in the Part column? Anyways, does anyone
know how I can make a formula to do this? Thank you.

Snakeoids.