Convert JSON to Excel Table - How to extract Array/List Values into One Cell
In this video, I show how to extract all List/Array values from JSON into a single cell in Excel.
Formula:
Table.TransformColumns(
#"Expanded Column1",
{
"your_column_name",
each Text.Combine(List.Transform(_, Text.From), ", "),
type text
}
)
#excel #exceltips #powerquery #json