Desktop •
360 Reference •
166 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(115) order-based calculation(12) split(10) transpose(9) group(7) csv(4) join(4) expand one row to multiple rows(3) merge(3) text files(3) interval query(2) file comparison(2) sql(2) intersection operation(1) duplicate ranks(1) big data(1) key values(1)
excel(115) order-based calculation(12) split(10) transpose(9) group(7) csv(4) join(4) expand one row to multiple rows(3) merge(3) text files(3) interval query(2) file comparison(2) sql(2) intersection operation(1) duplicate ranks(1) big data(1) key values(1)
-
blackduckie • Desktop • 1 Reply 440 View • 2021-01-12 02:15:13
How to Get Differences between Two Excel Sheets
-
blackduckie • Desktop • 1 Reply 381 View • 2021-01-12 00:55:18
Split a String by Comma and Get Desired Values for Each Substring
-
blackduckie • Desktop • 1 Reply 439 View • 2021-01-11 10:11:21
Convert Regular Text Data into Excel Data
-
-
blackduckie • Desktop • 1 Reply 431 View • 2021-01-11 07:27:41
Get Random Small Samples from a Huge Text File
-
blackduckie • Desktop • 1 Reply 470 View • 2021-01-11 04:20:00
Get Intersection of Two Filtered Subsets in Excel
-
-
blackduckie • Desktop • 1 Reply 424 View • 2021-01-08 02:49:09
How to Extract Numbers from Excel Cells
-
blackduckie • Desktop • 1 Reply 410 View • 2021-01-07 01:10:18
How to Perform Different Types of JOINs on Two Excel Sheets
-
blackduckie • Desktop • 1 Reply 434 View • 2021-01-06 03:00:51
Split and Expand Multiline Words in an Excel Cell into Multiple Rows
-
blackduckie • Desktop • 1 Reply 440 View • 2021-01-06 02:39:47
Dynamically Query the Interval a Given Value Belongs to in Excel
-
-
-
blackduckie • Desktop • 1 Reply 401 View • 2020-12-31 02:59:33
Compare Adjacent Rows and Group Data by a Specific Interval
-
blackduckie • Desktop • 1 Reply 432 View • 2020-12-31 01:33:21
Join Two CSV Files through the Key Field
-
blackduckie • Desktop • 1 Reply 506 View • 2020-12-29 08:24:43
How to List Empty Groups during Group-based Transposition on Excel Data
-
-
-
blackduckie • Desktop • 1 Reply 406 View • 2020-12-23 01:59:04
How to Parse KV Format（key=value) Excel Cells
-
blackduckie • Desktop • 1 Reply 454 View • 2020-12-22 09:49:25
Split an Excel Table by Time Interval and Expand It Horizontally
-
blackduckie • Desktop • 1 Reply 589 View • 2020-12-22 08:38:59
How to Split a Large Excel File into Smaller Files
-
blackduckie • Desktop • 1 Reply 493 View • 2020-12-15 10:55:49
Convert a Multi-row-based Table to a Regular Row-wise Table
-
blackduckie • Desktop • 1 Reply 433 View • 2020-12-14 01:17:30
Extend One Row to Multiple Rows by a Specific Rule
-
blackduckie • Desktop • 1 Reply 490 View • 2020-12-11 09:18:34
Group Excel Data and List Column Values Horizontally in Specific Order
-
blackduckie • Desktop • 1 Reply 1,467 View • 2020-12-08 11:53:50
Extract Data from a Specifically-patterned TXT File to Export to Excel