I have =A1 on one cell and then a bunch of text on 3 cells beneath it and then =A2 on the fourth cell beneath it, how to make sure that when i drag down, it goes to A3 after leaving 3 cells and so forth?
How to leave gaps while dragging down in Google Sheets?
google spreadsheets