Table Data Type - Expand values to single row and not multiple rows.

[StuartSmith]

Let me first put that I am using v.14 of the Power Bi API as v.15 incorrectly imports dates (1 day behind) from SP Lists and this is the only way I have been able to fix my issue.

Anyway, I have 2 imported columns within Bi that are showing as "Table" type... and these contain, either 0, 1 or multiple values.

and when I try to expend the table values, it creates multiple rows (1 value per row), but need the values all in one row.  API V.15 inports these columns as "Lists" and have the option to expand as either values or new rows which would be perfect, but as mentioned above, API 14, doesnt.  

API v.14

 

API v.15

How can I get the table vlaues all in one row cell?    If I have to go the multiple row route, is there then a way to concat the values into one row? Hope that makes sense and thanks in advance.

[lbendlin]

Use Text.Combine on the Value column of your table.