An introduction to Excel's very practical techniques for data manipulation

An introduction to Excel's very practical techniques for data manipulation

Do you know how to weigh the data? Do you know how to combine multiple columns of data into one column? If you do not know, then look, you will be finished! The following small series for everyone to bring Excel very practical data processing operation skills, hope to be helpful to everyone!

1, data to be heavy

The data in column 1th of the figure is duplicated

Select the data to be weighed and select the Data menu in the menu bar

Select "Remove Duplicates"

When you select Delete Duplicates, a dialog box pops up, choosing OK

After completing the above operation, the data can be done to redo the operation.

2. Multiple columns merged into one column

Here's how to combine the following a and B columns of data into one column and write the results to column C cells

In the C1 unit, enter: =A1&B1, and carriage return, you can merge the cell A1 and the contents of the unit B2 to fill in the C1 unit grid

Then pull down the C1 cell, and the system automatically merges the contents of the corresponding A and B column units into the cells in column C.

Note that cells cannot be formatted as text, and none of the formulas in Excel are valid

Above is excel very practical data processing operation skill detailed explanation, hoped can be helpful to everybody!