Hello All,
how can I convert multi rows data into single row using power query..
My above column must look like the below comlumn..
Thanks..
<tbody>
</tbody>
<tbody>
</tbody>
how can I convert multi rows data into single row using power query..
My above column must look like the below comlumn..
Thanks..
Driver Name | Driver ID | Bus Number | School ID | School Name | Timing |
David | 1005 | F5002 | A123 | Helen Model School | 7:15 |
David | 1005 | F5002 | A300 | Stuart High School | 8:00 |
<tbody>
</tbody>
Driver name | Driver ID | Bus Number | School ID1 | School Name1 | Timing1 | School ID2 | School Name2 | Timing2 |
David | 1005 | F5002 | A123 | Helen Model School | 7:15 | A300 | Stuart High School | 8:00 |
<tbody>
</tbody>