Create list of unique descriptions for each term

Hi -
I have a spreadsheet with a list of unique codes.
Each of those codes has a different description at our different facilities.

For each of those unique codes, I want to list a distinct instance of the descriptions.

For example - here is a sample of my codes and descriptions:

Code___Description1_____Description2_____Description3___Description4

7001 bottle can can aluminum_can
7002 wine beer liquor wine
7003 pretzel popcorn snack pizza

I want to see -

7001 bottle can aluminum_can
7002 wine beer liquor
7003 pretzel popcorn snack pizza

I'm pretty sure there is a fairly simple way to draw this out...
any help would be greatly appreciated!

Why not try the CONCATENATE formula...

CONCATENATE(Code," ",Description1," ",Description2," ",Description3," ",Description4)