Merging two row cells and repeating down a column (not down a row).
I'm familiar with, and found many help forums, on how to merge multiple cells in a row and repeat the process down a row. I.E. A1+A2, A3+A4, repeat. just by clicking and dragging. I'm asking how to merge rows down a column and repeat with a click and drag. I am working on formatting an excel sheet for an ArcGIS application. I have over 7,000 rows of data. Here's the problem. Set up/scenario: Column A has rows 1 and 2 separated (A1, A2), rows 3 and 4 separated (A3, A4), etc none of the rows down are merged (remember 7,000 plus rows). Columns B-G have rows 1 and 2 merged (B1+B2), rows 3 and 4 merged (B3+B4), all the way down the columns. Question: How do I get the cells in column A to match the merges in columns B-G and then click and drag the format or repeat it down the column so that A1+A2, A3+A4, etc down a single column (basically merging two rows over and over down a column. I hope there's an answer here! Thanks for your time all!