UK_GER
New member
Hi together,
I played around with the Text.ToList function.
Pls. see below:
The result for the Text "Ich" is:
Ich 1 I
Ich 1 c
Ich 1 h
How can I go the opposite way?
Coming from:
1 I
1 c
1 h
to Ich?
If someone has a hint - I would like to take it.
Thanks
Uwe
I played around with the Text.ToList function.
Pls. see below:
Code:
let
Quelle = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
#"Geänderter Typ" = Table.TransformColumnTypes(Quelle,{{"Text", type text}}),
#"Hinzugefügter Index" = Table.AddIndexColumn(#"Geänderter Typ", "Index", 1, 1),
#"Hinzugefügte benutzerdefinierte Spalte" = Table.AddColumn(#"Hinzugefügter Index", "Custom", each Text.ToList ([Text])),
#"Erweiterte Custom" = Table.ExpandListColumn(#"Hinzugefügte benutzerdefinierte Spalte", "Custom")
in
#"Erweiterte Custom"
The result for the Text "Ich" is:
Ich 1 I
Ich 1 c
Ich 1 h
How can I go the opposite way?
Coming from:
1 I
1 c
1 h
to Ich?
If someone has a hint - I would like to take it.
Thanks
Uwe