esProc Desktopesproc-desktop.hashnode.dev·19 hours ago#140 — Generate Continuous ArraysProblem description & analysis: There is a column of serial numbers (No), as shown in the figure below: Task: Now we want to use the two numbers in each row to expand into continuous number intervals, like this: Solution: Use SPL XLL and enter the ...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Feb 5, 2025#139 — Interconversion of Rows and Columns in Reverse OrderProblem description & analysis: Here below is a data table: Task: Now we want to transpose the M columns of a two-dimensional table to M rows, and the transposition order should be: the M-th column, M-1 column, M-2…2, 1. The results are as follows: ...10 likesexcel
TechInnovatorathlete.hashnode.dev·Feb 1, 2025'I knew I was good at Excel' - World champion finalistAn IT professional who thought he was "good at Excel" can now prove it after reaching the finals of a global competition. Harry Watson, 25, is a senior systems analyst in Sudbury, Suffolk. In December, he traveled to Las Vegas to compete in the World...World champion
esProc Desktopesproc-desktop.hashnode.dev·Jan 27, 2025#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple RowsProblem description & analysis: Here below is a data table: Task: Now we want to convert it to a row-based table, like this: Solution: Use SPL XLL and enter the following code: =spl("=E(?1).pivot@r(Names,Sales;Weekday,Day).new(Names,Sales,Day).sele...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jan 26, 2025#137 — Re-group or Sort When Filling Grouped Data into ColumnsProblem description & analysis: There is a data table. In this table, the products with the same name may have multiple colors. Task: Convert the data to the form as shown below, that is, arrange each type of product in one row, and then list the Na...excel
esProc Desktopesproc-desktop.hashnode.dev·Jan 24, 2025#136 — Put Data in a Group Horizontally into ColumnsProblem description & analysis: Here below is a data table: Task: Rank the students by score, and arrange the names with the same score into the same row. The result is as follows: Solution: Use SPL XLL and enter the following code: =spl("=E(?1).gr...10 likesexcel sheets
Casie Liucasie.hashnode.dev·Jan 23, 2025How to Add or Remove Cell Borders in Excel with Python [Comprehensive Tutorial]To make Excel sheets more visually organized, adding borders is a simple yet effective solution. Borders not only enhance the structure of the data but also help differentiate between sections or topics. However, manually setting and adjusting cell b...Python
esProc Desktopesproc-desktop.hashnode.dev·Jan 22, 2025#135 — Convert Crosstab to Row-Based TableProblem description & analysis: We have a crosstab that stores product’s style data (width and length) and price information. The width data are stored in the first row, and the length data are stored in the first column: Task: Now we want to conver...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jan 21, 2025#134 — Convert Row-Based Table to CrosstabProblem description & analysis: The following data table records the daily sales of products: Task: Now we want to create a crosstab, with the SaleDate as the left header of crosstab, and the Products as the upper headers of crosstab, like this: So...10 likesProgramming Blogs
Casie Liucasie.hashnode.dev·Jan 21, 2025XLS vs XLSX: Key Differences and How to Convert Them in PythonWhen working with Excel files, you may come across two formats: XLS and XLSX. While both formats seem similar and can be opened and used in MS Office, what exactly sets them apart? Why are there two formats in the first place? And most importantly, h...Python