Transform a list of records into columns

[sumsar10171]

Hi,

I have a challenge I can't seem to find a way around.

I have a table of contacts, with an email and a list of records:

Email	Fields
John@example.com	List
Peter@example.com	List

Each record is strucutered like so:

Name	Value
Address	221B Baker St., London
Occupation	Doctor
Age	40

What i am trying to do is end with a table like so:

Email	Address	Occupation	Age
John@example.com	221B Baker St., London	Doctor	40

The fields are completly dynamic, so i can't "Hardcode" the values I'm looking for.

Let me know if any additional information would help anwser my question. 

[wdx223_Daniel]

=Table.Combine(Table.ToList(PreviousStepName,each Table.FromRecords({[Email=_{0}]&Record.Combine(_{1})}))

[Anonymous]

Hi @sumsar10171 ,

I tried to reproduced it. Here's my solution.

1.Expand to New Rows

2.Expand again. Once expanded, right-click on all selected columns to fill up and down.

3.Remove duplicates

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sumsar10171]

Hi Stephen,

I really appriacte you taking the time to write this anwser.

I might have communicated a part of the problem poorly.

 Each record on the list looks like so

With the kind being the name of the field, and what should be made to the column name.

And value being the value for that field.

In the example you provided, a single record contained all the information.