Referring previous calculated row of the calculated column in power query

[yasiralifeeds]

Hi,

I want Supplier ID which is in column2 in Supplier ID: column to repeat and want it to replace & repeat new Supplier ID where the Coulumn1 contains Supplier ID: with changed ID in Column2 just like in below image. 

Thanks in advance for your help.

[yasiralifeeds]

Thanks Ahmadx for your reply. 

But I does not understand the logic of "0".."9" in this formula. =textText.Select([[Column2],{"0".."9"}) and function is showing error in red font color for dots ..

Any help will be highly appreciated.

[Ahmedx]

=textText.Select([[Столбец2],{"0" .. "9"})
-------
it is correct to write like this:

=textText.Select([Столбец2],{"0" .. "9"})

[Ahmedx · Accepted solution]

pls try this