Forum Discussion

Eric Redegeld's avatar
Eric Redegeld
Brass Contributor
Feb 16, 2021

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

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

     

    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 Redegeld's avatar
      Eric Redegeld
      Brass Contributor

      ExcelExciting 

       

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

      Thats the strenght of this tool, visible live data

       

       

      • ExcelExciting's avatar
        ExcelExciting
        MVP

        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.

Resources