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) text files(3) sql(2) caculate(1) key values(1)
excel(115) order-based calculation(12) split(10) transpose(9) group(7) csv(4) join(4) text files(3) sql(2) caculate(1) key values(1)
-
jinxing • Desktop • 253 View • 2024-06-24 16:58:52
Excel, find the maximum value and the neighboring N members before and after
-
jinxing • Desktop • 267 View • 2024-06-24 16:58:35
In Excel, combine multiple detail data columns into one row in each group
-
jinxing • Desktop • 244 View • 2024-06-24 16:58:16
In Excel, identify data layers correctly and convert them to a standardized table
-
blackduckie • Desktop • 1 Reply 516 View • 2020-12-31 09:33:21
Join Two CSV Files through the Key Field
-
blackduckie • Desktop • 1 Reply 584 View • 2020-12-29 16:24:43
How to List Empty Groups during Group-based Transposition on Excel Data
-
-
-
blackduckie • Desktop • 1 Reply 511 View • 2020-12-23 09:59:04
How to Parse KV Format（key=value) Excel Cells
-
blackduckie • Desktop • 1 Reply 556 View • 2020-12-22 17:49:25
Split an Excel Table by Time Interval and Expand It Horizontally
-
blackduckie • Desktop • 1 Reply 727 View • 2020-12-22 16:38:59
How to Split a Large Excel File into Smaller Files
-
blackduckie • Desktop • 1 Reply 592 View • 2020-12-15 18:55:49
Convert a Multi-row-based Table to a Regular Row-wise Table
-
blackduckie • Desktop • 1 Reply 521 View • 2020-12-14 09:17:30
Extend One Row to Multiple Rows by a Specific Rule
-
blackduckie • Desktop • 1 Reply 585 View • 2020-12-11 17:18:34
Group Excel Data and List Column Values Horizontally in Specific Order
-
blackduckie • Desktop • 1 Reply 1,566 View • 2020-12-08 19:53:50
Extract Data from a Specifically-patterned TXT File to Export to Excel
-
-
blackduckie • Desktop • 1 Reply 442 View • 2020-12-06 16:32:59
Directly Query Excel/Text Files Using SQL
-
blackduckie • Desktop • 1 Reply 580 View • 2020-12-04 17:21:54
Execute Excel-like Formulas outside Excel
-
blackduckie • Desktop • 1 Reply 542 View • 2020-12-04 16:37:33
Group & Summarize an XLS file without Using Excel
-
blackduckie • Desktop • 1 Reply 530 View • 2020-12-03 18:12:06
Get the Previous & Next Row of Same Group without Sorting the Excel Data
-
blackduckie • Desktop • 1 Reply 600 View • 2020-12-02 14:05:30
How to Use SQL to Query Data in Excel
-
-
blackduckie • Desktop • 1 Reply 656 View • 2020-11-12 15:30:55
Group & Summarize a Big Excel File Every N Rows
-
blackduckie • Desktop • 1 Reply 603 View • 2020-11-12 15:26:55
Dynamically Parse Expressions That Contain Cell Variables
-
blackduckie • Desktop • 1 Reply 593 View • 2020-11-12 15:24:31
Group & Summarize Excel Data with a Scripting Language
-
blackduckie • Desktop • 1 Reply 668 View • 2020-11-11 17:27:48
Get Values from Same Group by Relative Position in Excel