View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Niklas Niklas is offline
external usenet poster
 
Posts: 15
Default Linking from an old to a new table

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