Create new list with defined ranges
 

Hello, in shhet1 i have a list with values

now i would like to create a new list in sheet2, whit the values of sheet1,
but replaced by an predefined range.

e.g.
Sheet1, values rng1,rng2,rng3,etc
result in sheet2 should be
rng1.1
rng1.2
rng1.3
rng2.1
rng2.2
rng3.1
rng3.2, etc

I hope my question is clear to you,

Any help would be appreciated very much,
Thanks in advance



--
There are only 10 types of people in the world:
Those who understand binary and those who don''''''''''''''''t.