API upload: How to create a table with one row for titles another row for values.

[Diegoloubet]

Hi!,

I´ve uploaded into Power bi data using an API call. The data is a table, but what I see in Power BI is a row with a list of values for the titles and another row with a list with the rows of that table.

I would need to convine them some how using PowerQuery to create the actual table. I´ve tried pivot, unpivot and other transformations but I was not able to do it. I believe a formula will easy sort it out, but do not find which one. 

If I select the Columns List, convert into table, expand I get something like this: (these are the column titles)

If I select the "rows" list, convert to table and expand, I´ll get something like this: (this is the id of the values, and the values in the same order as the titles)

What I need is:

ID	Epic % Complete	Epic assigned to	Epic Comments	Epic ID	Epic Name
7151264482758330911		Default (Unassigned)		7151264482758330911	Design Spike for re-arechitected...
5790500850808504508	value for id2	value for id2	value for id2	value for id2	value for id2

[v-xiaoyan-msft]

Hi @Diegoloubet  , 

Can you provide a simple sample to help us better solve your problem.
We need to see the format of the raw data to determine if it works.
Your demo can have only simple values and formats, please be careful not to provide sensitive information.

Best Regards,
Community Support Team _ Caitlyn

[Diegoloubet]

Thanks! I have edited my post to provide examples