-
SQL, compute cumulative sums according to the termination condition
Application • 0 Reply • 161 View • 2024-08-19 17:39 -
-
In an Excel table, find rows corresponding to the 1st and the last non-empty cells in each column
Desktop • 0 Reply • 161 View • 2024-08-19 14:03 -
-
SQL, concatenate multiple rows of strings and remove duplicates
Application • 0 Reply • 131 View • 2024-08-16 15:26 -
SQL, output associated records having many-to-many relationship row by row
Application • 0 Reply • 160 View • 2024-08-15 15:54 -
-
Copy each row N times (N is the cell value of the specified column)
Desktop • 0 Reply • 134 View • 2024-08-14 15:36 -
-
Group rows and combine non-null values in each of non-grouping columns
Desktop • 0 Reply • 277 View • 2024-08-09 15:40 -
-
-
-
SQL, split values of two columns respectively and count members of their intersection
Application • 0 Reply • 190 View • 2024-08-07 18:08 -
Group and summarize rows while retaining columns whose values are unchanged
Desktop • 0 Reply • 183 View • 2024-08-06 16:04 -
SQL, Set different flags for different groups according to whether there are duplicate values
Application • 0 Reply • 246 View • 2024-08-06 16:02 -
Get duplicate records from a csv file and sort them
Application • 0 Reply • 275 View • 2024-08-05 17:30 -
-
Define a dynamic range of columns and perform aggregation
Desktop • 0 Reply • 143 View • 2024-08-05 09:25 -
Retrieve multiple columns from a csv file to generate a new file
Application • 0 Reply • 170 View • 2024-08-02 14:02 -
Clear duplicate lines and lines having missing values from a csv file
Application • 0 Reply • 171 View • 2024-08-01 15:37 -
Group columns of an Excel table and perform aggregation
Desktop • 0 Reply • 202 View • 2024-08-01 14:32 -
Merge multiple files, remove duplicates and sort the result
Application • 0 Reply • 191 View • 2024-07-31 18:28 -
-
-
-
-
Retrieve a specified column from a csv file and concatenate its values as a string
Application • 0 Reply • 177 View • 2024-07-26 08:32 -
-
Find the row containing the maximum value from a text file
Application • 0 Reply • 129 View • 2024-07-24 19:32