Showing data in a table horizontally
It looks to me like you are trying to 'pivot' the data, which can be done with multiple case statements:

test data:


create table timestream(
  idTimestream integer primary key autoincrement
, time int not null
, value float not null
, idSensor integer not null);

  
  

insert into timestream(time, value, idSensor) values(1,0.1,100);

  
  

insert into timestream(time, value, idSensor) values(1,0.2,101);

  
  

insert into timestream(time, value, idSensor) values(1,0.3,102);

  
  

insert into timestream(time, value, idSensor) values(2,0.4,101);



query:


select time, sum(case idSensor when 100 then value end) as s100,
             sum(case idSensor when 101 then value end) as s101,
             sum(case idSensor when 102 then value end) as s102
from timestream
group by time;



time | s100 | s101 | s102
:--- | :--- | :--- | :---
1    | 0.1  | 0.2  | 0.3 
2    | null | 0.4  | null



dbfiddle here