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
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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...?
 
Joined
Jul 27, 2016
Messages
2
Reaction score
0
Data is in horizontal in another sheet and in sequence like 1,2,3...
and it is not efficient way to link all cell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top