Hello,

A similar question was asked in this post, for me the suggested approach works just fine, check if it works for you.

Hi,

thank you.

Hmm i stucked a little. 

I tried example from link above and i finished with:

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Building", type text}, {"Device", type text}, {"Ports", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.Repeat("z",[Ports])),
#"Split Column by Position" = Table.ExpandListColumn(Table.TransformColumns(#"Added Custom", {{"Custom", Splitter.SplitTextByRepeatedLengths(1), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Custom"),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Position",{{"Custom", type text}})
in
#"Changed Type1"

What i am missing?

Best,
Jacek

You could use something like this I think:

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Building", type text}, {"Device", type text}, {"Ports", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Counter", each {1..[Ports]}),
#"Expanded Counter" = Table.ExpandListColumn(#"Added Custom", "Counter")
in
#"Expanded Counter"

Hello,

Velouria's code gives a better result. But to answer your question, you got the expected result for that text split code, so nothing missed on your part. You got a new row for each z in the custom column, it is however not counting as what Velouria's code does.

Hi,

thank you very much.

It is working. 
Ok so the link above is not doing the right solution? 

One question:

{1..[Ports]} what these ".." means within list? 
Best,
Jacek

hi Jaryszek,

The .. in {1..[Ports]} means include all numbers from 1 to [Ports]

Further reading Power Query Lists • My Online Training Hub

regards

Phil