-
-
Group an EXCEL table and concatenate values of rows meeting the specified condition
Desktop • 0 Reply • 135 View • 2024-08-20 15:03 -
SQL, compute cumulative sums according to the termination condition
Application • 0 Reply • 120 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 • 126 View • 2024-08-19 14:03 -
-
SQL, concatenate multiple rows of strings and remove duplicates
Application • 0 Reply • 87 View • 2024-08-16 15:26 -
SQL, output associated records having many-to-many relationship row by row
Application • 0 Reply • 128 View • 2024-08-15 15:54 -
-
Copy each row N times (N is the cell value of the specified column)
Desktop • 0 Reply • 103 View • 2024-08-14 15:36 -
-
Group rows and combine non-null values in each of non-grouping columns
Desktop • 0 Reply • 236 View • 2024-08-09 15:40 -
-
-
-
SQL, split values of two columns respectively and count members of their intersection
Application • 0 Reply • 144 View • 2024-08-07 18:08 -
Group and summarize rows while retaining columns whose values are unchanged
Desktop • 0 Reply • 149 View • 2024-08-06 16:04 -
SQL, Set different flags for different groups according to whether there are duplicate values
Application • 0 Reply • 178 View • 2024-08-06 16:02 -
Get duplicate records from a csv file and sort them
Application • 0 Reply • 232 View • 2024-08-05 17:30 -
-
Define a dynamic range of columns and perform aggregation
Desktop • 0 Reply • 115 View • 2024-08-05 09:25 -
Retrieve multiple columns from a csv file to generate a new file
Application • 0 Reply • 122 View • 2024-08-02 14:02 -
Clear duplicate lines and lines having missing values from a csv file
Application • 0 Reply • 124 View • 2024-08-01 15:37 -
Group columns of an Excel table and perform aggregation
Desktop • 0 Reply • 163 View • 2024-08-01 14:32 -
Merge multiple files, remove duplicates and sort the result
Application • 0 Reply • 132 View • 2024-07-31 18:28 -
-
-
-
-
Retrieve a specified column from a csv file and concatenate its values as a string
Application • 0 Reply • 129 View • 2024-07-26 08:32