Excel table Multi-column Data Merge animation tutorial

Excel2003 Introductory Animation tutorial 65, Excel table Multi-column data merge.

Demo Animation

Operation Steps

If you need to display more than one column of data in an Excel table to a column, you can use the merge function to do so.

If you want to display column B data and c column data in the D column (add a "-" symbol in the middle), a "&" is done.

Select the D1 cell, enter the formula:=b1& "-" &c1, confirm it, and then use the fill handle to copy it to the cell below the D column.

Tips

If you change the above formula to: =concatenate (B1, "-", C1), you can also achieve the purpose of merging.