Multi rows into Single row using power query

[alipezu]

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..
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]Driver Name[/TD]
[TD]Driver ID[/TD]
[TD]Bus Number[/TD]
[TD]School ID[/TD]
[TD]School Name[/TD]
[TD]Timing[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]1005[/TD]
[TD]F5002[/TD]
[TD]A123[/TD]
[TD]Helen Model School[/TD]
[TD]7:15[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]1005[/TD]
[TD]F5002[/TD]
[TD]A300[/TD]
[TD]Stuart High School[/TD]
[TD]8:00[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 900"]
<tbody>[TR]
[TD]Driver name[/TD]
[TD]Driver ID[/TD]
[TD]Bus Number[/TD]
[TD]School ID1[/TD]
[TD]School Name1[/TD]
[TD]Timing1[/TD]
[TD]School ID2[/TD]
[TD]School Name2[/TD]
[TD]Timing2[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]1005[/TD]
[TD]F5002[/TD]
[TD]A123[/TD]
[TD]Helen Model School[/TD]
[TD]7:15[/TD]
[TD]A300[/TD]
[TD]Stuart High School[/TD]
[TD]8:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[alipezu]

Sorry, My above table must look like the table below..