:"Solution and correct usage guide for data sorting error pop-ups"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Solution and correct usage guide for data sorting error pop-ups"

"Solution and correct usage guide for data sorting error pop-ups"

Author: daogeziyuan • • Table skills • Views 729
When we use spreadsheet software to process data, we sometimes encounter situations where we need to merge multiple scattered column data into one column. Here are the steps to merge multiple columns of data and split them into columns: 1. First, we need to merge multiple columns of data into a single column. Taking columns A and B as an example, you can enter the formula `=A2&B2` in the first cell (C2) of adjacent column C, so that the data in cells A2 and B2 can be merged. 2. Next, select the remaining cells in column C, click the "Fill" function in the "Home" tab, and then select "Fill Down", which will automatically apply the formula to other cells in column C. Complete the merge operation of all rows. 3. Then, select all the merged columns and use the shortcut key `Ctrl+C` to copy the data of this column. Next, right-click and select "Paste Special" and select "Paste as Value" in the pop-up menu. This step is to remove the formulas from the data and keep only the results. 4. Next, the merged but still uneven content needs to be aligned according to categories. Select the "Data" tab and click the "Sort into Columns" button. 5. In the Column Sorting Wizard, check the "Column by spaces" checkbox so that the data in the column can be automatically split based on spaces. 6. Add column lines at the end of the data cells such as phone number, name, gender, etc. to complete the column division. The following are related picture resources to help you understand the whole process more intuitively: - Demarcation line picture: [Demarcation line.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/0d91795edc000ab021bee695df6295e6 .png)- Merge data and fill down: [Record_2021_09_18_17_42_30_183.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/42027f5a80ab8734afbb758805fcca5b.gif)- Paste special as numeric value: [Recording_2021_09_18_17_43_06_269.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/e3ef5ff21548212261b88f4b62d5b6f8.gif)-Split operation: [Recording_2021_09_18_17_44_35 _461.gif](https://font2020 .oss-cn-beijing.aliyuncs.com/wps/images/7b5ce73767f91b2bf448dd3b413b3c78.gif) Please operate according to these steps and pictures to complete the merging and sorting of data.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-ju-fen-lie-cuo-wu-tan-chuang-de-jie-jue-fang-an-yu-zheng-que-shi-yong-zhi-nan.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu QH-慧语 Columnist
48 196
single-end

Related Suggestion