Create new list with defined ranges

B

BKO

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need function to raplace cell value by a range 2
Search function 0
How to connect two columns in Excel VBA?? 4
Split list query for Vlookups 1
Varying cell ranges in formulas according to number of cells with certain value 1
concatenate dynamic ranges 7
Creating a new table from another - filtering out unwanted data 8
If AND for large range of data 1

Top