Multi rows into Single row using power query

Hello All,
how can I convert multi rows data into single row using power query..
Thanks..

maybe like this:

The 'Driver ID' is missing in your created table..

What is your Excel version?
Ex2007 doesn't support PQ

corrected file


If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.