How to expand individual cells with data type "table" within a string column type

[Diegomon]

Hello all, in the screenshot below I have a table with a column combining string and table cells, therefore, you cannot see the "expand symbol" when you have a table column, how can I do to expand all cells and have everything as a string?

[Diegomon · Accepted solution]

I found the solution:

ExpandCell = Table.ReplaceValue(#"Replaced Comment",each [SSC_x002f_NonSSC],each try List.First(Table.Column(List.First(Table.Column([SSC_x002f_NonSSC],"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata")), "Attribute:null")) otherwise [SSC_x002f_NonSSC],Replacer.ReplaceValue,{"SSC_x002f_NonSSC"})

[Anonymous]

HI @Diegomon,

Can you please share some dummy data that keep the raw structure? They should help us clarify your scenario and and test:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Regards,

Moonlight