-
-
jinxing • Desktop • 200 View • 2024-07-01 09:56:51
Split & group text and perform distinct on each group
-
jinxing • Application • 267 View • 2024-07-01 08:39:05
Convert a rowwise CSV file to a multilayer JSON string
-
jinxing • Desktop • 215 View • 2024-06-26 10:21:11
Split each cell value and expand it according to the specified rule
-
jinxing • Application • 289 View • 2024-06-26 09:22:53
Filter a CSV file and re-arrange it by category
-
jinxing • Desktop • 222 View • 2024-06-24 21:21:00
Import a txt file where separator is missing in a column to Excel
-
-
jinxing • Desktop • 226 View • 2024-06-24 17:00:03
In Excel, parse hexadecimal numbers and make queries
-
jinxing • Desktop • 227 View • 2024-06-24 16:59:47
In Excel, search a target value and hide columns to its right
-
jinxing • Desktop • 242 View • 2024-06-24 16:59:29
In Excel, judge whether a word has duplicate letters
-
jinxing • Desktop • 221 View • 2024-06-24 16:58:52
Excel, find the maximum value and the neighboring N members before and after
-
jinxing • Desktop • 239 View • 2024-06-24 16:58:35
In Excel, combine multiple detail data columns into one row in each group
-
jinxing • Desktop • 221 View • 2024-06-24 16:58:16
In Excel, identify data layers correctly and convert them to a standardized table
-
jinxing • Desktop • 291 View • 2024-06-11 21:25:43
In Excel, concatenate the top 3 members in each group into a string
-
jinxing • Desktop • 231 View • 2024-06-11 15:40:55
In Excel, expand all combinations of multiple columns
-
raqsoft • Download • 287 View • 2024-06-06 09:17:52
Download esProc Latest Version『Release:20240403』
-
raqsoft • Download • 270 View • 2025-02-24 16:39:58
Download esProc Latest Version『Release:20240602』
-
jinxing • Desktop • 258 View • 2024-06-04 16:26:43
In Excel, enter values of same category in cells on the right of the grouping cell in order
-
-
jinxing • Desktop • 266 View • 2024-06-04 08:04:22
In Excel crosstab, transpose cross cells to columns and rows to cross cells
-
jinxing • Desktop • 249 View • 2024-05-31 09:38:37
Excel Perform COUNT on each category and concatenate results into a string
-
jinxing • Desktop • 327 View • 2024-05-30 15:57:19
In Excel, align every two columns to present them while setting missing values as 0
-
jinxing • Desktop • 257 View • 2024-05-28 16:01:59
In Excel, insert group headers to detail data rows in each group
-
-
jinxing • Desktop • 332 View • 2024-05-24 22:01:21
Excel Split each row in a group into multiple rows according to the specified rule
Recent hot
- SPL Operates Multi-layer JSON Data Much More Conveniently than DuckDB
- SPL assists MongoDB: To filter a JavaScript array based on matches
- SPL assists MongoDB: Replace substring in array of objects with nested objects
- Comparison of esProc SPL and DuckDB in Multi-Data Source Capabilities
- SPL assists MongoDB: Convert response into array of object
- SPL assists MongoDB: Only keep the running total for the last item in the partition
- esProc SPL vs DuckDB: Which is more Lightweight for In-Application Computation
- Distinctive Positional Operations
- From SQL to SPL:Create columns from distinct values of a column
- From SQL to SPL: Aggregate according to time interval