Expand excel column

[FBerdial]

Hi, 

I´m new in power Bi and need help.

I have an excel column tabulated as shown in color column.

How can transform it in one or three colums as shown?. I have to iterate de table but i don´t now how to recover values from previous files or store values in parameter who can change.

Please help!

[dufoq3]

Hi @FBerdial, I can try but could you provide sample data? I don't know how to simulate your [Sección] column

[FBerdial]

Hi dufoq3,

I'do with this sentences 

#"Columna condicional agregada" = Table.AddColumn(#"Filas filtradas", "Seccion", each if [Longitud] = 2 then [Sección] else null),
Relleno = Table.FillDown(#"Columna condicional agregada", {"Seccion"}),
#"Columna condicional agregada1" = Table.AddColumn(Relleno, "Programa", each if [Longitud] = 4 then [Sección] else null),
Relleno1 = Table.FillDown(#"Columna condicional agregada1",{"Programa"}),
#"Columna condicional agregada2" = Table.AddColumn(Relleno1, "Subconcepto", each if [Longitud] = 6 then [Sección] else "000000"),
#"Personalizada agregada" = Table.AddColumn(#"Columna condicional agregada2", "Indice", each [Seccion]&[Programa]&[Subconcepto])

Thanks for your help