Feb 16 2021 12:49 AM
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
Feb 16 2021 01:50 AM
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.
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.
Feb 16 2021 10:42 PM - edited Feb 16 2021 11:37 PM
thank you for replying, does this also work for the live stream.
Thats the strenght of this tool, visible live data
Feb 27 2021 03:57 AM
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.
Mar 03 2021 12:44 PM