excel master helps, B, C, D columns are placed under column A

Suppose b, c, d....Column G is placed under column A.

a1: =b1&c1&d1&e1&f1&g1

And copy the formula drop-down to other cells in column A.

First of all, the number of data you have cannot exceed 65536. In addition, to assume that the number of data in each column is the same, the following formula assumes that each column is 15, and as many columns as you want.

0,mod(row(),15),15)) Drag down. If there were originally 100 pieces of data per column, then:

0,mod(row(),100),100))

The basic operation is as mentioned above, if you want to add some separators such as "," or spaces to separate the columns, the formula in A1 is as follows=B1&","&c1&","&d1&","&e1 and so on.

If it is a space, replace the comma in the double quotation marks with a space (note: double quotation marks and commas are symbols in English format).

=a1*b1*c1/d1

Press Enter.

Excel four operations.

For example, in the A1 to A5 region and the B6 cell format, A1 to A5 are 1, 2, 3, 4, 5, and B6 is 6

Addition =sum(a1:a5,b6).

a1+a2+a3+a4+a5+b6

A1 to A5 and B6 add up to 21

Subtraction =sum(a1:a5)-b6

a1+a2+a3+a4+a5-b6

The addition of A1 to A5 minus B6 is 9

Multiplication =product(a1:a5,b6)=a1*a2*a3*a4*a5*b6

The multiplication of A1 to A5 and B6 is 720

Division = product(a1:a5) b6=a1*a2*a3*a4*a5 b6

Multiply a1 to a5 and subtract b6 to 20

The cells that are entered into the formula cannot be cells that have been referenced in the formula, so as not to form a loop to calculate the cell name (also known as the address).

There is a horizontal row of a, b, c, d in **... Such letters, each letter represents a column, called the column label, there is a vertical row of numbers on the side, called the row number, each number represents a row, the column and the row form the cell address, for example, the first cell (that is, the cell where A and 1 intersect) refers to the A1 cell, the cell where B and 2 intersect is called B2 cell, and the cell where C and 5 intersect is C5 cell.

With the indirect function, textual references, 1 23 4

5 a b data data.

b2b3 45

george 10

Formula Description (result).

Indirect($a$2) Reference value in cell A2 (=indirect($a$3) Reference value in cell A3 (45)=indirect($a$4) If cell B4 has the definition name "george", the value of the definition name (10) is returned

indirect("b"&$a$5) reference value (62) in cell A5

Step 3: Set it up as shown below.

Step 4: Set it up as shown below.