Linking from an old to a new table

[Niklas]

Hello,

I have a problem with recreating something I did along time ago. I have a
table with two columns, column A containing a list of numbers and column B a
list of names. Now I want to create a table where the row A1:B1 is repeated
as many times as the number in column A.

Now, I have previosuly done this with the help of a formula that look
something like: {=$A$1:$B$1 } being repeated in the new table A1 times. What
does the { } do? Am I making any sense at all? Any help is greatly
appreciated.

Best Regards
Niklas

 

[Ken Johnson]

Hello,

I have a problem with recreating something  I did along time ago. I have a
table with two columns, column A containing a list of numbers and column B a
list of names. Now I want to create a table where the row A1:B1 is repeated
as many times as the number in column A.

Now, I have previosuly done this with the help of a formula that look
something like: {=$A$1:$B$1 } being repeated in the new table A1 times.What
does the { } do? Am I making any sense at all? Any help is greatly
appreciated.

Best Regards
Niklas

After selecting the appropriate cells where you are wanting the
repeats and typing the formula =$A$1:$B$1 into the active cell (the
one not shaded), press Ctrl+Shift+Enter.
Excel added the {}s because it ia an array formula.

Ken Johnson