Create Colunms from Records

Hey

I need to be able to merge multiple columns into one record like seen below

Before

After

Many thanks in advance
Joe

Accepted answers

I mocked up a solution. See attached.

Can you provide this data as excel or paste the data here instead of a image.

We will be happy to help 🙂

I mocked up a solution. See attached.

In the final use dynamic rename to replace "_" to space your output will be near to expected output 🙂

After that i think column header sequence is a headache 😅