Column of Dynamic Parameter Names and Column of Associated Values into 2 or 3 columns

[asmith314]

Hello Everyone,

In the attached Sample workflow, I have a sample data set that consist of a Column that contains a Client Id, a column that consist of Parameter Names, and a column that consist of Parameter values. These Parameter Names are the Header for each Parameter value. These Parameter Names could be different for each client and the quantity number of parameters names could be different from client to client. I need a way to dynamically turn whatever quantity and values that are received into 2 or 3 columns that eventually looks like the output in the sample but in multiple columns.

Any suggestions? It is probably super easy to do but nothing I have tried so far has worked.

 

Ultimately I need the data to look like this (I used a photo editor to make this with the fields)

[binuacs]

@asmith314 I like the way you arrange your table data, that is something new to me. Thanks for that. To avoid repeated steps I created a standard macro and added in the workflow

[binuacs · Accepted solution]

@asmith314 I also updated your solution with macro

[asmith314]

That's awesome, Thanks a bunch @binuacs!