I have a large table I am constructing out of two other tables. The combined table is being built on Sheet 1, while the two tables I'm building it from are on Sheets 2 & 3. I want to pattern to look something like this for the first row of the first sheet (the combined table):
I tried manually writing out about the first ten cells and filling in the rest. However when I try to extend it, it doesn't follow the desired pattern. Is there some trick to doing this correctly?
Thank you in advance for your help.