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 ...
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
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
- 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