View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Transposing Links Every Certain Amount of Rows

Let us say you want to start your new table in the new sheet in cell
D6. Then the following formula

=OFFSET(Sheet1!$A$13,FLOOR((ROW()-ROW($D$6))*11,11)+MOD(COLUMN()-COLUMN($D$6),11),0)

can be copied across 11 columns and down as far as necessary and will
produce an 11-column table with what you are asking (I believe). If you
need to CONCATENATE (which is what you are apparently referring to as
LINK) the values you can do this next to the data with a formula like:

=CONCATENATE(D6, E6, ..., N6)

HTH
Kostis Vezerides