Create Colunms from Records

[jmckenna97]

Hey 

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

Before 

After 

Many thanks in advance
Joe

[atcodedog05]

Hi @jmckenna97 

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

We will be happy to help 🙂

[PhilipMannering · Accepted solution]

Hey @jmckenna97 

I mocked up a solution. See attached.

[atcodedog05]

Hi @PhilipMannering 

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 😅

[PhilipMannering]

@atcodedog05 Good catch. Though had to use a regex expression: 

regex_replace([_CurrentField_], '_(\d+)$', ' \1')

 ...so that it didn't change the earlier underscores... :S

[jmckenna97]

Thanks for your help 🙂