Pivoting MySQL - Transforming sensor values under separate columns instead of each line

[Anonymous]

I get 3 rows every time my sensor logs data. I want to transform the table in Power Bi desktop so I can group each of these rows by the date/time stamp and sort all the sensor values under different columns. Added a screen shot of what it looks like and how I want to tenasform it.  Any suggestions? 

PS: Sorry, for the noob question

[d_gosbell · Accepted solution]

In the query editor start by getting rid of the id_channel, id_certificate and value_raw columns. Then click on the "systemlog_001.channel.name_sys" column, then under the transform tab click on the "Pivot Column" button and choose the value_col column as your Values Column in the pivot dialog.

[Anonymous]

Worked like a charm! Thanks a lot