Converting vertical to horizontal data

[SH_94]

Dear community,

May i know how can i convert the following to the output below?

The list of above is just an example and in my list, i have more than 100 line and would like to ask how we can combine in this case?

Thank you.

[Qiu · Accepted solution]

@SH_94 
A Summarize tool should do it.