adding new Colums at Query editor from Table

[bdaniel2]

Hey everyone. Im new in the PowerBI section and i need some help.
what i did so far is to Merge Queries from two tables and now i got one table with the new coulmn "ROUTE DATA" (like in the picture below)
and in each row theres Table (i opened one of the tables like you can see in the picture)
so I dont know how to create a new coulmns for each ID for every row in the Table. like you can see in the pictures (the red cells i added).

hope you can help me with it.
Thanks Daniel

 

[gazpage]

Erm, did you click on the expand column icon in the header? To the right of where it says ROUTE DATA in orange?

 

[bdaniel2]

Erm, did you click on the expand column icon in the header? To the right of where it says ROUTE DATA in orange?

Yes but that’s not what I want to get. If I will do that I will get a few rows for the same ID but I want only one row for one ID but with the details from the new “table”

 

[bdaniel2]

someone can help me please?
Thanks.

 

[peter789]

Follow the suggestion exactly in post two and it should do what you require. Try it and post what you get if the results are not as expected.