Transposing Links Every Certain Amount of Rows
 

I have data from F13 to F1299. I want to transpose and LINK every 11 cells
down column F to a new row on a new worksheet.

For example, every 2 cells down on a new row:
1
2
3
4
goes to
12
34

Is there any quick way to do this? Thanks.

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

Transposing Links Every Certain Amount of Rows
 

Wow, worked great. Can you explain to me how that worked? As in, what does
offset, floor, mod, etc. mean? Can you break apart the formula so I know how
it works... I mean when you have time of course. Thanks!

"vezerid" wrote:

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