Merging two row cells and repeating down a column (not down a row).

Dear Benajamin Fork,

Method 1

Step 1. Select Cells B1 to B7000

Step 2. Copy

Step 3. Select cell A1.

Step 4. Right click > Paste special > Formats

Method 2

Step 1. Select cells B1 to B7000.

Step 2. Select Format Painter

Step 3. Click cell A1. All Formats will get pasted.

Important Information:

In case, data is present in cells A1, A2, A3, A4..., then you may need to merge the data before you perform the operation of merging of cells.

One way to do this is by using a temporary helper column. The joining (merging) of data shall depend on the type of data. I am giving an example of text data. In case of numbers or other type of data, then you need to take adequate precautions.

For text data:

In cell C1, enter the formula =A1&" "&A2.

Select cells C1 and C2 and drag down the formula, till cell C7000.

Copy cells C1 to C7000.

In cell A1, Paste Special > Values.

The data from cells C1 to C7000 will get pasted in cells A1 to A7000.

Delete the data in cells C1 to C7000.

I hope this solves your problem.

Regards,

Vijaykumar Shetye,

Spreadsheet Excellence,

Panaji, Goa, India