Excel Vertical to horizontal repeat after 16 rows

Joined
Jul 27, 2016
Messages
2
Reaction score
0
I have data in sheet 1 from b1 to an1 and i wanted to repeat data in sheet 2 horizontally so i used =offset($b$1,0,row(a1)-1) the data comes sequencely but i want to repeat sequence after 16 rows. Ex.
If data is in a1 then sequence should come in a16 rather than a2

Please help
 
Welcome to the forum :)

I'm not sure what you mean... If you want to repeat data from a different sheet, you can simply link one cell to another - just type = in the cell and then click on the cell you want to link it to (ie the cell in the other sheet). The resulting formula will look something like "=Sheet1!A1". If you do the top left cell in the data set first, you can drag the formula to all other cells by clicking and dragging the little square in the bottom right-hand corner of the cell.

I don't know if that is answering your question though...?
 
Data is in horizontal in another sheet and in sequence like 1,2,3...
and it is not efficient way to link all cell
 
Back
Top