Analyst •
294 Reference •
196 Reply •
1 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(109) clipboard(13) order-based calculation(12) split(10) transpose(9) group(7) csv(4) join(4) expand one row to multiple rows(3) merge(3) sql(3) text files(3) difference operation(3) locate calculation(2) interval query(2) file comparison(2) intersection operation(1) duplicate ranks(1) big data(1) record split(1)
excel(109) clipboard(13) order-based calculation(12) split(10) transpose(9) group(7) csv(4) join(4) expand one row to multiple rows(3) merge(3) sql(3) text files(3) difference operation(3) locate calculation(2) interval query(2) file comparison(2) intersection operation(1) duplicate ranks(1) big data(1) record split(1)
-
blackduckie • Analyst • 1 Reply 260 View • 2021-01-20 09:48:27
How to Locate the Nearest Row of the Same Catagory
-
blackduckie • Analyst • 1 Reply 347 View • 2021-01-20 07:53:05
Sort out Columns According to a Specific Column
-
blackduckie • Analyst • 1 Reply 216 View • 2021-01-18 06:44:25
How to Remove Common Data of Strings from One of Them
-
blackduckie • Analyst • 1 Reply 266 View • 2021-01-18 01:25:56
How to Split a String by Data Types to Perform Aggregation
-
blackduckie • Analyst • 1 Reply 243 View • 2021-01-15 07:26:34
How to Split away Unwanted Characters from a String
-
blackduckie • Analyst • 1 Reply 263 View • 2021-01-15 01:33:49
How to Judge Whether a Value is the Largest One in a Group
-
blackduckie • Analyst • 1 Reply 259 View • 2021-01-14 09:12:17
List Missing Columns for Row-to-Column Transposition
-
blackduckie • Analyst • 1 Reply 304 View • 2021-01-12 07:12:49
Convert a Crosstab to a Row-wise Table
-
blackduckie • Analyst • 1 Reply 341 View • 2021-01-12 02:15:13
How to Get Differences between Two Excel Sheets
-
blackduckie • Analyst • 1 Reply 283 View • 2021-01-12 00:55:18
Split a String by Comma and Get Desired Values for Each Substring
-
blackduckie • Analyst • 1 Reply 317 View • 2021-01-11 10:11:21
Convert Regular Text Data into Excel Data
-
-
blackduckie • Analyst • 1 Reply 303 View • 2021-01-11 07:27:41
Get Random Small Samples from a Huge Text File
-
blackduckie • Analyst • 1 Reply 331 View • 2021-01-11 04:20:00
Get Intersection of Two Filtered Subsets in Excel
-
-
blackduckie • Analyst • 1 Reply 299 View • 2021-01-08 02:49:09
How to Extract Numbers from Excel Cells
-
blackduckie • Analyst • 1 Reply 302 View • 2021-01-07 01:10:18
How to Perform Different Types of JOINs on Two Excel Sheets
-
blackduckie • Analyst • 1 Reply 316 View • 2021-01-06 03:00:51
Split and Expand Multiline Words in an Excel Cell into Multiple Rows
-
blackduckie • Analyst • 1 Reply 328 View • 2021-01-06 02:39:47
Dynamically Query the Interval a Given Value Belongs to in Excel
-
-
-
blackduckie • Analyst • 1 Reply 292 View • 2020-12-31 02:59:33
Compare Adjacent Rows and Group Data by a Specific Interval
-
blackduckie • Analyst • 1 Reply 327 View • 2020-12-31 01:33:21
Join Two CSV Files through the Key Field
-
blackduckie • Analyst • 1 Reply 347 View • 2020-12-29 08:24:43
How to List Empty Groups during Group-based Transposition on Excel Data
-