Desktop •
360 Reference •
166 Reply •
0 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(115) clipboard(13) order-based calculation(12) split(10) add-in(10) transpose(9) group(7) inter-row calculation(4) join(4) expand one row to multiple rows(3) text files(3) align(2) locate calculation(2) interval query(2) file merge(2) difference operation(2) percentage(1) duplicates(1) record split(1) key values(1) cross product(1) more>>> json(1)
excel(115) clipboard(13) order-based calculation(12) split(10) add-in(10) transpose(9) group(7) inter-row calculation(4) join(4) expand one row to multiple rows(3) text files(3) align(2) locate calculation(2) interval query(2) file merge(2) difference operation(2) percentage(1) duplicates(1) record split(1) key values(1) cross product(1) more>>> json(1)
-
-
blackduckie • Desktop • 1 Reply 434 View • 2020-12-14 01:17:30
Extend One Row to Multiple Rows by a Specific Rule
-
blackduckie • Desktop • 1 Reply 494 View • 2020-12-15 10:55:49
Convert a Multi-row-based Table to a Regular Row-wise Table
-
blackduckie • Desktop • 1 Reply 590 View • 2020-12-22 08:38:59
How to Split a Large Excel File into Smaller Files
-
blackduckie • Desktop • 1 Reply 456 View • 2020-12-22 09:49:25
Split an Excel Table by Time Interval and Expand It Horizontally
-
blackduckie • Desktop • 1 Reply 408 View • 2020-12-23 01:59:04
How to Parse KV Format（key=value) Excel Cells
-
-
blackduckie • Desktop • 1 Reply 491 View • 2020-12-11 09:18:34
Group Excel Data and List Column Values Horizontally in Specific Order
-
blackduckie • Desktop • 1 Reply 399 View • 2021-01-29 09:42:02
How to List All Permutations of Members from Multiple Sets
-
blackduckie • Desktop • 1 Reply 441 View • 2021-02-01 00:37:15
How to Select Records by Specified Percentage of a Specific Field
-
blackduckie • Desktop • 1 Reply 496 View • 2021-02-01 00:39:58
How to Achieve Interval-based VLOOKUP in Excel
-
blackduckie • Desktop • 1 Reply 337 View • 2021-02-01 01:14:15
How to Get the Maximum Value in Continuous Non-null Cells
-
blackduckie • Desktop • 1 Reply 1,556 View • 2021-01-27 07:20:04
How to Convert a Grouped Excel File That Contains Merged Cells into JSON Format
-
blackduckie • Desktop • 1 Reply 1,468 View • 2020-12-08 11:53:50
Extract Data from a Specifically-patterned TXT File to Export to Excel
-
blackduckie • Desktop • 1 Reply 435 View • 2021-01-27 02:45:40
How to Combine Rows and Columns of Multiple CSV Files
-
blackduckie • Desktop • 1 Reply 346 View • 2021-01-25 09:14:11
How to Get the Next Value of the Cell Meeting the Specific Condition
-
blackduckie • Desktop • 1 Reply 311 View • 2021-01-25 08:00:07
How to Group Rows, Perform Distinct and Then Transposition
-
blackduckie • Desktop • 1 Reply 417 View • 2021-01-25 07:02:55
How to Insert an Empty Row Wherever the Excel Cell Value Is Changed
-
blackduckie • Desktop • 1 Reply 371 View • 2021-01-22 12:00:21
How to Shuffle Values Randomly in a Specific Area in Excel
-
blackduckie • Desktop • 1 Reply 360 View • 2021-01-22 09:39:08
How to Group and Aggregate If Neighboring Rows Meet the Specified Condition
-
blackduckie • Desktop • 1 Reply 302 View • 2021-01-21 08:13:43
How to Add Missing Values in a Continuous Sequence
-
blackduckie • Desktop • 1 Reply 382 View • 2021-01-20 09:48:27
How to Locate the Nearest Row of the Same Catagory
-
blackduckie • Desktop • 1 Reply 505 View • 2021-01-20 07:53:05
Sort out Columns According to a Specific Column
-
blackduckie • Desktop • 1 Reply 316 View • 2021-01-18 06:44:25
How to Remove Common Data of Strings from One of Them
-
blackduckie • Desktop • 1 Reply 359 View • 2021-01-18 01:25:56
How to Split a String by Data Types to Perform Aggregation