Merge Record and rename columns

[Newtoalteryx]

Hi! I need to merge these records based on unique id and rename column names accordingly.

Also, I need the data to enter a new row if the no of names > 3. Thanks!

The first table is the input and the second table is the desired output.

Sorry for the confusion! 

[aatalai]

@Newtoalteryx based on the ask of the join here you go, but it looks like you might need a tranpose could get you from one to another.

Also for future reference desired output/outcome can help in getting your issue resolved.

You can rename columns in the join tool or add another select and do it there

[Newtoalteryx]

Thanks for your time!

I am sorry my post lacked clarity.  I have edited it. Please let me know if you have a solution for this. Thanks!

[aatalai · Accepted solution]

@Newtoalteryx thanks for the update take a look at this 

[Newtoalteryx]

Hey! That worked like a charm. Thanks so much!!😁