# copy different Horizontal data to vertical

#### johnny52

##### Active Member
=IFERROR(INDEX(A\$1:H\$9,CEILING(ROWS(E\$1:E2)/8,1)*4-3,MOD(ROWS(E\$1:E2)+7,8)+1),""

This formula works for my 8 columns and 1 row of horizontal data (converts it to vertical in column i1 thru i8)

How can I copy this formula to a lower part of the worksheet where I have different row data (but the same columns),not the constant (E\$1:E2) from just the first row

I can't seem to follow what this formula is doing (E\$1:E1)/8,1)*4-3 and MOD(ROWS(E\$1:E1)+7,8)+1),"") looks like it just reading that first row

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### AlphaFrog

##### MrExcel MVP
Change the A\$1:H\$9 to the "different row data". The rest of the formula is the same.

#### johnny52

##### Active Member
Change the A\$1:H\$9 to the "different row data". The rest of the formula is the same.
Thanks, but I kind of want a formula to change this automatically ....the worksheet is quite large

#### AlphaFrog

##### MrExcel MVP
Are we to assume that "different row data" means you want the formula to change to the next 9 rows every time you drag it down nine rows?

#### johnny52

##### Active Member
Are we to assume that "different row data" means you want the formula to change to the next 9 rows every time you drag it down nine rows?
yes if that's possible

Thanks

Replies
3
Views
105
Replies
2
Views
54
Replies
5
Views
75
Replies
9
Views
213
Replies
9
Views
383