Split data rows datastreamer

Occasional Contributor

Hi all, we have got an working datastreamer. 

Data retrieved from the Microbit ar visible. Only it is one row

 

Is there a way to split the data from

C02

400

Tvoc

600

 

To 

 

Co2     Tvoc

400      600

 

We are planning to make a weather station so wind speed and temperature are also recieved as data.

 

with regards

Eric Redegeld

 

4 Replies

Hi @Eric Redegeld 

 

The easiest way to handle this situation is by using the Power Query. 

 

You can use the same file to convert your existing data as well.

Just paste the information in the blue table > select the green table > right click > refresh

 

Your data will be organized.

 

Snag_e3cbdb.png

Kindly find attached is the sample file.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

@Faraz Shaikh 

 

thank you for replying, does this also work for the live stream.

Thats the strenght of this tool, visible live data

 

 

Hi @Eric Redegeld 

 

That's awesome, don't forget mark is solved so that it will be helpful for other members to find it more.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Hi problem stil present, but due the time and covid my attention got elswhere.
Power Query? is there some tutorial how to set this up.
regard
Eric