Build a table based on column values

[FrankieMcQ]

Hi

I have a table consisting of a single column of variable names coming from a JSON request. The length of the list can change over time:

VariableNames

Name

ID

Due Date

etc.

I also have a list of Job IDs, gain populated from a JSON request:

Job ID

Job1

Job2

Job3

etc.

I can then build a JSON query that returns me a list of values for each variable name:

Job ID    Variable Name   Variable Value

Job1       Name                   Joe

Job1       ID                         0001

Job2       Name                   Bob

Job3       ID                         0002

So, basically I want to merge this information into a single table that looks something like this:

JobID    Name        ID       FutureVariable

Job 1     Joe            0001   ...

Job 2     Bob           0002   ...

I've tried all sorts of combinations without success. Any help gratefully received.

[Zubair_Muhammad · Accepted solution]

@FrankieMcQ

Try Pivoting the Variable Name Column with Variable Value as Values...Do not Aggregate

See the attached file as well

[FrankieMcQ]

I tried this an it worked perfectly, many thanks for your help!