Combine data from multiple rows into a single row

My apologies for the long post... I've been wrestling with this for awhile and am at wit's end...

I have a table of data that contains the results of chemical analyses of water samples. There is a column with a single unique ID for each sample, and over 90 columns with the various chemical parameters (i.e., variables) and the associated data. The problem is that the data are scattered across multiple rows for each sample/analysis. Here's an example: 

This is what I have:

I need to consolidate the samples into this:

Here are the complicating issues:

• There is no rhyme or reason to the distribution of data - it's not like, for example, row 1 always has Var2, 3, 4, 7,; row 2 always has Var1, 5, 6, etc.; so I can't assume that each sample will have a consistent distribution of data
• Some of the variables have the same data in multiple rows (e.g., Var6 and Var7 in the example above)
• Some of the values are not considered numbers by Excel (see Var8 above)
• The overall data table has thousands of samples; hundreds of them have multiple rows and the number of multiple rows ranges from 2-5 rows per sample. I can do this manually, but it will take at least an entire day to get through everything.

Does anyone know of a simple way to do this? Pivot tables won't work because of the non-numeric entries. I've looked into the Power Query tool, but can't figure out how to do this with so many variable columns. Any help would be greatly appreciated.

-Matt