Home > Software engineering >  Gather rows results from query into one row with google sheet
Gather rows results from query into one row with google sheet

Time:10-09

I am filtering a weekly timetable regarding a certain day. The results are displayed on two rows as follow : hours and corresponding content. I'd like to merge each result into single cells as : hours corresponding content. I unsuccesfully tried with the functions join, concat, concatenate. In addition, I'd like to have an arrayformula in order not to repeat the function in other rows.

enter image description here

I would appreciate some help. THank you

Here is my sheet enter image description here

  • Related