Merging rows with blank values

[Rywek]

As you can see in the following table, I have a number of entries and lots of blank cells. It just so happens that every entry either has a single value or no value on each row.

What I need to do is to merge the rows with common entry numbers to form a single row with all the data intact and to do this for 5 000+ entries over 20 000+ rows.

Entry	Col1	Col2	ValueCol1	ValueCol2	ValueCol3	ValueCol4
Entry 1	Car		Value 1
Entry 1	Car					Value 4
Entry 1		Truck			Value 3
Entry 1		Truck		Value 2
Entry 2	Car		Value 1
Entry 2	Car				Value 3
Entry 2		Truck				Value 4
Entry 2		Truck
Entry 3	Car		Value 1
Entry 3	Car			Value 2

[JieJenn]

Is each entry list 4 times?

[Rywek]

Unfortunately, no. A same entry may appear 1-12 times.

There isn't really any logical pattern to this, aside from the fact that for any value column, there is only a single possible value.