-
Group an Excel table and store as multiple files according to part of value of the specified cell
Desktop • 0 Reply • 168 View • 2024-07-18 10:13 -
-
-
Group and summarize a table where every N rows consist of a range by column
Desktop • 0 Reply • 263 View • 2024-07-16 16:13 -
SQL, split up a field according to whether the specified characters are unique or not
Application • 0 Reply • 146 View • 2024-07-16 09:52 -
-
Get two numbers from each of the two sets of numbers and let them equal to a specified value
Application • 0 Reply • 167 View • 2024-07-15 09:21 -
-
Write continuous numbers in a string of numbers as intervals
Desktop • 0 Reply • 213 View • 2024-07-11 16:25 -
Repeat value of each cell N times according to value of the neighboring cell
Desktop • 0 Reply • 211 View • 2024-07-09 21:08 -
-
-
-
Concatenate column values and perform grouping & aggregation
Desktop • 0 Reply • 247 View • 2024-07-05 14:04 -
Summarize data every two columns under each category
Desktop • 0 Reply • 277 View • 2024-07-04 21:37 -
-
Filter a CSV file according to condition and output result as a list
Application • 0 Reply • 251 View • 2024-07-04 15:54 -
Convert irregular format CSV to standard JSON strings
Application • 0 Reply • 270 View • 2024-07-04 15:08 -
Rearrange an irregular text file into a two-dimensional table
Application • 0 Reply • 232 View • 2024-07-01 11:24 -
-
Split & group text and perform distinct on each group
Desktop • 0 Reply • 219 View • 2024-07-01 09:56 -
Convert a rowwise CSV file to a multilayer JSON string
Application • 0 Reply • 297 View • 2024-07-01 08:39 -
Split each cell value and expand it according to the specified rule
Desktop • 0 Reply • 241 View • 2024-06-26 10:21 -
-
Import a txt file where separator is missing in a column to Excel
Desktop • 0 Reply • 248 View • 2024-06-24 21:21 -
-
In Excel, parse hexadecimal numbers and make queries
Desktop • 0 Reply • 250 View • 2024-06-24 17:00 -
In Excel, search a target value and hide columns to its right
Desktop • 0 Reply • 250 View • 2024-06-24 16:59 -
In Excel, judge whether a word has duplicate letters
Desktop • 0 Reply • 271 View • 2024-06-24 16:59 -
Excel, find the maximum value and the neighboring N members before and after
Desktop • 0 Reply • 253 View • 2024-06-24 16:58