Desktop •
360 Reference •
166 Reply •
0 Follow
Follow
-
jinxing • Desktop • 307 View • 2024-09-05 11:06:03
Search for a specified string across the whole table
-
-
jinxing • Desktop • 389 View • 2024-09-03 16:24:47
Find how many times two specified members will be contained in a series of sets
-
-
jinxing • Desktop • 230 View • 2024-09-02 16:09:13
Split each row into multiple rows according to the specified rule
-
jinxing • Desktop • 187 View • 2024-08-30 15:09:56
Concatenate column titles corresponding to empty cells
-
-
-
jinxing • Desktop • 234 View • 2024-08-27 16:25:35
Combine cell values of every 3 rows under each column into one cell
-
jinxing • Desktop • 339 View • 2024-08-26 14:10:54
Get desired data every N rows and combine them into one row
-
-
jinxing • Desktop • 263 View • 2024-08-22 16:06:59
Get rankings of Excel rows in each group while retaining the existing order
-
jinxing • Desktop • 225 View • 2024-09-19 18:57:24
Group and Summarize rows and add different words after different counts
-
jinxing • Desktop • 233 View • 2024-08-20 15:03:12
Group an EXCEL table and concatenate values of rows meeting the specified condition
-
-
-
jinxing • Desktop • 193 View • 2024-08-15 15:52:42
Find the category meeting the specified condition
-
jinxing • Desktop • 177 View • 2024-08-14 15:36:47
Copy each row N times (N is the cell value of the specified column)
-
jinxing • Desktop • 334 View • 2024-08-09 15:40:14
Group rows and combine non-null values in each of non-grouping columns
-
-
-
jinxing • Desktop • 233 View • 2024-08-06 16:04:13
Group and summarize rows while retaining columns whose values are unchanged
-
-
jinxing • Desktop • 190 View • 2024-08-05 09:25:46
Define a dynamic range of columns and perform aggregation
-
jinxing • Desktop • 271 View • 2024-08-01 14:32:18
Group columns of an Excel table and perform aggregation