Creating databanks automatically using existing data

[rwwilcox]

Hello,

I am looking to automatically produce databanks from some statistics gathered.

cell A1 = ABC
cell A2 = 4

cell B1 = DEF
cell B2 = 10

The result I am looking for is ABC to be inserted into 40 rows, 1 column (A2 multiplied by 10) then directly underneath DEF to be inserted into 100 rows (10 multiplied by 10) and so on until there are no more rows in column A & B.

Is this possible? If so could someone please offer some advice on how exactly?


ABC 4 ABC
DEF 10 ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
....
DEF..

[JBeaucaire]

Did you mean:

1) Strings are listed in row 1
2) numbers are listed in row 2
3) Create a new list with strings in from row1 listed 10xRow2 numbers.

Your example is a bit jumbled.