title: How can I transpose from a column to rows an employee timesheet data
body: <p>I have a employee timesheet data in 1 column and need to transpose this to lines and columns.</p>
  <p><strong>Original data with 1 column</strong></p>
  <pre><code>mon
  
  02/05/2022
  
  9:04
  
  12:47
  
  13:52
  
  18:09
  
  -
  
  -
  
  tue
  
  03/05/2022
  
  9:13
  
  13:03
  
  14:06
  
  18:10
  
  -
  
  -
  
  wed
  
  04/05/2022
  
  8:58
  
  12:57
  
  14:08
  
  18:19
  
  -
  
  -
  
  thu
  
  05/05/2022
  
  8:52
  
  12:26
  
  13:32
  
  17:39
  
  -
  
  -
  
  fri
  
  06/05/2022
  
  10:13
  
  13:10
  
  14:15
  
  18:14
  
  -
  
  -
  
  sat
  
  07/05/2022
  
  -
  
  -
  
  -
  
  -
  
  -
  
  -
  
  sun
  
  08/05/2022
  
  -
  
  -
  
  -
  
  -
  
  -
  
  -
  
  mon
  
  09/05/2022
  
  8:49
  
  12:46
  
  13:48
  
  18:11
  
  -
  
  -
  
  tue
  
  10/05/2022
  
  8:52
  
  12:51
  
  13:55
  
  18:07
  
  -
  
  -
  </code></pre>
  <p><strong>Transposed data to table with lenght 8 columns</strong></p>
  <pre><code>mon 02/05/2022  9:04    12:47   13:52   18:09   -   -
  
  tue 03/05/2022  9:13    13:03   14:06   18:10   -   -
  
  wed 04/05/2022  8:58    12:57   14:08   18:19   -   -
  
  thu 05/05/2022  8:52    12:26   13:32   17:39   -   -
  
  fri 06/05/2022  10:13   13:10   14:15   18:14   -   -
  
  sat -   -   -   -   -   -   -
  
  sun -   -   -   -   -   -   -
  
  mon 09/05/2022  8:49    12:46   13:48   18:11   -   -
  
  tue 10/05/2022  8:52    12:51   13:55   18:07   -   -
  </code></pre>
  <p>How can I do it? I tryed with <code>=TRANSPOSE(QUERY</code> functions but didn't got what I expected.</p>
  <p>Thank you!</p>