Creating a Unique ID (correlating multiple items) based on data in columns and rows

[bleu]

Hi Community, 

Does any body have any ideas on the best way to get the desired output below?

A number can have multiple fruit and a fruit can have multiple numbers. How do I tie that together for each item. I tried concatenating the data, separating into rows, joining etc. and it's getting messy.

Data			Desired Output
123456	Apple		123456	123456- Apple-Pear-Banana
789101	Lime		789101	789101-Lime
111213	Pineapple		111213	111213-Pineapple
141516	Lemon		141516	141516-Lemon
123456	Pear		123456	123456- Apple-Pear-Banana
555777	Orange		555777	555777-Orange
123456	Banana		123456	123456- Apple-Pear-Banana
171819	Grape		171819	171819-202122-Grape
232425	Peach		232425	232425-Peach
202122	Grape		202122	171819-202122-Grape
			Apple	123456- Apple-Pear-Banana
			Lime	789101-Lime
			Pineapple	111213-Pineapple
			Lemon	141516-Lemon
			Pear	123456- Apple-Pear-Banana
			Orange	555777-Orange
			Banana	123456- Apple-Pear-Banana
			Grape	171819-202122-Grape
			Peach	232425-Peach
			Grape	171819-202122-Grape