:Use column sorting techniques to organize data efficiently-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Use column sorting techniques to organize data efficiently

Use column sorting techniques to organize data efficiently

Author: daogeziyuan • • Table skills • Views 960
The column sorting function is mainly used to effectively distinguish data. For example, we have a piece of data in the same column, and now we want to divide the data into three columns based on name, date of birth, and gender. By using the sort function, we can quickly organize this data. The location of the column sorting operation is the "Sort to Columns" option in the "Data" menu. First, select the cells that need to be sorted into columns, and then click "Sort to Columns". In the next interface, you can choose to use delimiters to separate columns or fixed-width columns. For delimited columns, the system will recognize the delimiting symbols contained in the field, such as commas, periods, etc. By default, the system recognizes half-width commas and periods. If you need to use full-width symbols, you can enter them manually in "Other Symbols" and then view the separation effect in the preview window. After clicking "Next" you can set the column data type. In the preview window, you can select the data type of the corresponding column, or choose not to import a certain column of data. The target area defaults to the currently selected data area as the first column position of the column, but you can also manually select the insertion area after the data is divided. After completing the settings, click "Finish" to achieve column sorting. Fixed-width column separation is performed by selecting a fixed interval position of the field. After setting the column spacing position, you can create a column line by clicking in the preview window, double-click the column line to delete it, or hold down the column line to move it to a specified position. Similarly, click "Next" to set the data type of each column, and then click "Finish" to complete the column sorting operation. The following is a link to the image to illustrate the operation: - [Picture and text alignment diagram.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/e1ea7da86ff61befb1c583b6784f105d.png) - [Recording_2019_07_12_09_43_12_880. gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/e49265a7de4fbb1d14d5644c3f881f6b.gif)-[recording_2019_07_12_09_44_59_278.gif](https://font2020.oss-cn-beijing.aliyuncs . com/wps/images/8e6d362236d17bc1f9c6c4248e164d0d.gif)-[Record_2019_07_12_09_45_41_606.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/def37cca3625778631 e9ebcc5d5adfee.gif) Please note that the above link is the original Click on the image address provided in the article to directly view the relevant image.

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/li-yong-fen-lie-ji-qiao-gao-xiao-zheng-li-shu-ju.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 许春麒 Columnist
48 196
single-end

Related Suggestion