Forum Discussion
Split data rows datastreamer
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
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.
- Eric RedegeldBrass Contributor
thank you for replying, does this also work for the live stream.
Thats the strenght of this tool, visible live data
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.