Desktop •
360 Reference •
166 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(115) clipboard(13) order-based calculation(12) split(10) transpose(9) group(7) inter-row calculation(4) join(4) expand one row to multiple rows(3) merge(3) text files(3) align(2) locate calculation(2) interval query(2) file comparison(2) sql(2) difference operation(2) intersection operation(1) duplicate ranks(1) big data(1) duplicates(1) more>>> record split(1) column-wise storage(1)
excel(115) clipboard(13) order-based calculation(12) split(10) transpose(9) group(7) inter-row calculation(4) join(4) expand one row to multiple rows(3) merge(3) text files(3) align(2) locate calculation(2) interval query(2) file comparison(2) sql(2) difference operation(2) intersection operation(1) duplicate ranks(1) big data(1) duplicates(1) more>>> record split(1) column-wise storage(1)
-
blackduckie • Desktop • 1 Reply 389 View • 2021-01-25 16:00:07
How to Group Rows, Perform Distinct and Then Transposition
-
blackduckie • Desktop • 1 Reply 524 View • 2021-01-25 15:02:55
How to Insert an Empty Row Wherever the Excel Cell Value Is Changed
-
blackduckie • Desktop • 1 Reply 471 View • 2021-01-22 20:00:21
How to Shuffle Values Randomly in a Specific Area in Excel
-
blackduckie • Desktop • 1 Reply 458 View • 2021-01-22 17:39:08
How to Group and Aggregate If Neighboring Rows Meet the Specified Condition
-
blackduckie • Desktop • 1 Reply 392 View • 2021-01-21 16:13:43
How to Add Missing Values in a Continuous Sequence
-
blackduckie • Desktop • 1 Reply 476 View • 2021-01-20 17:48:27
How to Locate the Nearest Row of the Same Catagory
-
blackduckie • Desktop • 1 Reply 615 View • 2021-01-20 15:53:05
Sort out Columns According to a Specific Column
-
blackduckie • Desktop • 1 Reply 424 View • 2021-01-18 14:44:25
How to Remove Common Data of Strings from One of Them
-
blackduckie • Desktop • 1 Reply 436 View • 2021-01-18 09:25:56
How to Split a String by Data Types to Perform Aggregation
-
blackduckie • Desktop • 1 Reply 405 View • 2021-01-15 15:26:34
How to Split away Unwanted Characters from a String
-
blackduckie • Desktop • 1 Reply 484 View • 2021-01-15 09:33:49
How to Judge Whether a Value is the Largest One in a Group
-
blackduckie • Desktop • 1 Reply 476 View • 2021-01-14 17:12:17
List Missing Columns for Row-to-Column Transposition
-
blackduckie • Desktop • 1 Reply 562 View • 2021-01-14 16:12:14
How to Group & Sort Column Values Automatically
-
blackduckie • Desktop • 1 Reply 501 View • 2021-01-12 15:12:49
Convert a Crosstab to a Row-wise Table
-
blackduckie • Desktop • 1 Reply 527 View • 2021-01-12 10:15:13
How to Get Differences between Two Excel Sheets
-
blackduckie • Desktop • 1 Reply 478 View • 2021-01-12 08:55:18
Split a String by Comma and Get Desired Values for Each Substring
-
blackduckie • Desktop • 1 Reply 548 View • 2021-01-11 18:11:21
Convert Regular Text Data into Excel Data
-
-
blackduckie • Desktop • 1 Reply 550 View • 2021-01-11 15:27:41
Get Random Small Samples from a Huge Text File
-
blackduckie • Desktop • 1 Reply 594 View • 2021-01-11 12:20:00
Get Intersection of Two Filtered Subsets in Excel
-
-
blackduckie • Desktop • 1 Reply 517 View • 2021-01-08 10:49:09
How to Extract Numbers from Excel Cells
-
blackduckie • Desktop • 1 Reply 513 View • 2021-01-07 09:10:18
How to Perform Different Types of JOINs on Two Excel Sheets
-
blackduckie • Desktop • 1 Reply 531 View • 2021-01-06 11:00:51
Split and Expand Multiline Words in an Excel Cell into Multiple Rows
-
blackduckie • Desktop • 1 Reply 528 View • 2021-01-06 10:39:47
Dynamically Query the Interval a Given Value Belongs to in Excel