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.
I would appreciate some help. THank you