Expand column containing both text and table types

[Anonymous]

Hi,

I have an XML file where almost all columns contain mostly tables and can be expanded easily in the UI. However some columns contain both text and table types.

An example:

There isn't an "Expand" button in the column header. Is there anyway to expand these columns even though some cells contain text?

Thanks,

TR

[Anonymous]

Very Very Very HELPFUL !!! THX!!!

[ImkeF]

You have to transform the column before expanding: https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi...

Table.TransformColumns(Source, {{“Scope Description”, each if Value.Is(_, type table) then _ else #table({"Column1"}, {{_}} ) }} )

[prateekraina · Accepted solution]

Hi,

You can use below code in a step in the Query Editor.

Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type table) then _ else #table({“Column1”}, {{_}} ) }} )

Reference:
https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi...
Written by @ImkeF

Prateek Raina

[Anonymous]

Thanks - worked like a charm!