Trying create a summary of data.

[O177812]

Hi,

I am trying to create a report in excel based on data on a different sheet.

On "Sheet 2" I have the following data:

ITEM	TITLE	COLOR	ERRORS	DATA
54256	Big Cup	RED	1	MISSING SIZE
63562	Large Sweater	BLUE	2	MISSING WEIGHT MISSING LENGTH

<tbody>
</tbody>

I would like the following output to be input in 1 cell on sheet 1:

_____________________________________


Please address the following errors:

The data for ITEM 54256 contains (1) error(s):

MISSING SIZE

The data for ITEM 54256 contains (2) error(s):

MISSING WEIGHT
MISSING LENGTH


_____________________________________


Thanks for your help!