MY SQL Zeilen in Spalten

Hi ihr,
ich suche eine Möglichkeit meine Tabelle PIVOT zu machen.

Meine Tablle sieht wie folgt aus:


VarName TimeString VarValue
Test 1 17.08.2018 07:45:00 320
Test 1 raum 17.08.2018 07:45:00 300
Test 2 17.08.2018 18:00:00 360
Test 2 raum 17.08.2018 18:00:00 301


Natürlich ist das nur eine vereinfachte Darstellung ich hab unter der Uhrzeit noch viel mehr werte.
Brauchen tue ich jetzt:

TimeString Test 1 Test 1 Raum Test 2 Test 2 Raum
17.08.2018 07:45:00 320 300
17.08.2018 18:00:00 360 301


Im Prinzip will ich meine Zeilen zu Spalten ändern und es Gruppieren anhand von TimeString.

Ich hab schon Probiert.

select TimeString
,(select VarName from tablle_rohdaten where VarName = Test 1) as Test 1
,(select VarName from tablle_rohdaten where VarName = Test 1 Raum) as Test 1 Raum
,(select VarName from tablle_rohdaten where VarName = Test 2) as Test 2
,(select VarName from tablle_rohdaten where VarName = Test 2 Raum) as Test 2 Raum
from tablle_rohdaten

Nur leider bekomm ich nichtmal die ausgabe ich bekomme nur: Reference 'Test 1' not supported (forwad reference in item list)

ich bin mir sicher es geht irgendwie... ich brauch bloß wieder hilfe wie.

Ich bedanke mich im Voraus.

Marcel

PS: ich nutze MySQL

SELECT t.TimeString,
t1.VarValue AS test1,
t2.VarValue AS test1_raum,
t3.VarValue AS test2,
t4.VarValue AS test2_raum
FROM (
SELECT TimeString
FROM table_rohdaten
GROUP BY TimeString
) t
LEFT JOIN table_rohdaten t1 ON t.TimeString = t1.TimeString AND t1.VarName = 'Test 1'  
LEFT JOIN table_rohdaten t2 ON t.TimeString = t2.TimeString AND t2.VarName = 'Test 1 Raum'  
LEFT JOIN table_rohdaten t3 ON t.TimeString = t3.TimeString AND t3.VarName = 'Test 2'  
LEFT JOIN table_rohdaten t4 ON t.TimeString = t4.TimeString AND t4.VarName = 'Test 2 Raum'  

SELECT t.*
FROM (
SELECT TimeString
FROM table_rohdaten
GROUP BY TimeString
) t

SELECT t.TimeString,
t1.VarValue AS test1,
t2.VarValue AS test1_raum,
t3.VarValue AS test2,
t4.VarValue AS test2_raum
FROM (
SELECT TimeString
FROM table_rohdaten
GROUP BY TimeString
) AS t
LEFT JOIN table_rohdaten t1 ON t.TimeString = t1.TimeString AND t1.VarName = 'Test 1'  
LEFT JOIN table_rohdaten t2 ON t.TimeString = t2.TimeString AND t2.VarName = 'Test 1 Raum'  
LEFT JOIN table_rohdaten t3 ON t.TimeString = t3.TimeString AND t3.VarName = 'Test 2'  
LEFT JOIN table_rohdaten t4 ON t.TimeString = t4.TimeString AND t4.VarName = 'Test 2 Raum'  

SELECT t.*
> FROM (
> SELECT TimeString
> FROM table_rohdaten
> GROUP BY TimeString
> ) t

SELECT t.TimeString,
> t1.VarValue AS test1,
> t2.VarValue AS test1_raum,
> t3.VarValue AS test2,
> t4.VarValue AS test2_raum
> FROM (
> SELECT TimeString
> FROM table_rohdaten
> GROUP BY TimeString
> ) AS t
> LEFT JOIN table_rohdaten t1 ON t.TimeString = t1.TimeString AND t1.VarName = 'Test 1'  
> LEFT JOIN table_rohdaten t2 ON t.TimeString = t2.TimeString AND t2.VarName = 'Test 1 Raum'  
> LEFT JOIN table_rohdaten t3 ON t.TimeString = t3.TimeString AND t3.VarName = 'Test 2'  
> LEFT JOIN table_rohdaten t4 ON t.TimeString = t4.TimeString AND t4.VarName = 'Test 2 Raum'  

SELECT cast('21.08.2018 13:00:00' AS DATETIME)  

LEFT JOIN misch_rohdaten t9 on t.TimeString = t9.TimeString DATE_FORMAT(t9.TimeString, '%y.%m.%d %H:%i:%s')