-
-
Concatenate column values and perform grouping & aggregation
Desktop • 0 Reply • 236 View • 2024-07-05 14:04 -
Summarize data every two columns under each category
Desktop • 0 Reply • 268 View • 2024-07-04 21:37 -
-
Filter a CSV file according to condition and output result as a list
Application • 0 Reply • 239 View • 2024-07-04 15:54 -
Convert irregular format CSV to standard JSON strings
Application • 0 Reply • 259 View • 2024-07-04 15:08 -
Rearrange an irregular text file into a two-dimensional table
Application • 0 Reply • 223 View • 2024-07-01 11:24 -
-
Split & group text and perform distinct on each group
Desktop • 0 Reply • 216 View • 2024-07-01 09:56 -
Convert a rowwise CSV file to a multilayer JSON string
Application • 0 Reply • 285 View • 2024-07-01 08:39 -
Split each cell value and expand it according to the specified rule
Desktop • 0 Reply • 237 View • 2024-06-26 10:21 -
-
Import a txt file where separator is missing in a column to Excel
Desktop • 0 Reply • 241 View • 2024-06-24 21:21 -
-
In Excel, parse hexadecimal numbers and make queries
Desktop • 0 Reply • 245 View • 2024-06-24 17:00 -
In Excel, search a target value and hide columns to its right
Desktop • 0 Reply • 243 View • 2024-06-24 16:59 -
In Excel, judge whether a word has duplicate letters
Desktop • 0 Reply • 256 View • 2024-06-24 16:59 -
Excel, find the maximum value and the neighboring N members before and after
Desktop • 0 Reply • 246 View • 2024-06-24 16:58 -
In Excel, combine multiple detail data columns into one row in each group
Desktop • 0 Reply • 260 View • 2024-06-24 16:58 -
In Excel, identify data layers correctly and convert them to a standardized table
Desktop • 0 Reply • 237 View • 2024-06-24 16:58 -
In Excel, concatenate the top 3 members in each group into a string
Desktop • 0 Reply • 308 View • 2024-06-11 21:25 -
In Excel, expand all combinations of multiple columns
Desktop • 0 Reply • 248 View • 2024-06-11 15:40 -
In Excel, generate a list of all days of the month where a specified date belongs
Desktop • 1 Reply • 286 View • 2024-06-05 17:57 -
In Excel, enter values of same category in cells on the right of the grouping cell in order
Desktop • 0 Reply • 272 View • 2024-06-04 16:26 -
-
In Excel crosstab, transpose cross cells to columns and rows to cross cells
Desktop • 0 Reply • 276 View • 2024-06-04 08:04 -
Excel Perform COUNT on each category and concatenate results into a string
Desktop • 0 Reply • 275 View • 2024-05-31 09:38 -
In Excel, align every two columns to present them while setting missing values as 0
Desktop • 0 Reply • 347 View • 2024-05-30 15:57 -
In Excel, insert group headers to detail data rows in each group
Desktop • 0 Reply • 275 View • 2024-05-28 16:01 -
Excel Get the max and min values of each column in each group and insert them into cells horizontally
Desktop • 0 Reply • 395 View • 2024-05-28 08:33