POWER QUERY: Transform list into rows or extract values ​​from a list

[mlozano]

Hello!! I have a list that really only has one year, but I need to extract the year or convert that list to rows.

My function M is the following:

Table.ExpandListColumn(Date[Year])

I also tried with:

Table.TransformColumns(Date[Year], {"Date[Year]", each Text.Combine(List.Transform(_, Text.From)), type text})

In both I get an error, does anyone know how I can correct it?

[ChrisMendoza · Accepted solution]

@mlozano - try something like