G
Guest
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.
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.