How does mysql Merge multiple rows into one row and mysql multiple rows?

How does mysql Merge multiple rows into one row and mysql multiple rows?

Select group_concat (list_name) from aa_list

How to merge multiple rows of data into one row in excel

If you want to merge data of A1, A2, and A3 into one row, enter the following formula in the new line:
= CONCATENATE (A1, A2, A3)

How to combine multiple rows of data in EXCEL into one row of data?

Merge
K1 = CONCATENATE (A1, B1, C1, D1, E1, F1, G1, H1, I1, J1)
Then, in K4 = CONCATENATE (K1, K2, K3), K4 is the result of these numbers joining together.

If you just want to extract it to become the corresponding cell of the first row, copy and paste it directly, or select the area of the next row of cells, move the cursor to the position you want to place when the cursor turns into a four-way development arrow.

If you calculate these numbers = SUM (A1: J3)