Analyst •
294 Reference •
196 Reply •
1 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(109) order-based calculation(12) split(10) transpose(9) group(7) sql(3) text files(3) key values(1) spl xll(1)
excel(109) order-based calculation(12) split(10) transpose(9) group(7) sql(3) text files(3) key values(1) spl xll(1)
-
-
blackduckie • Analyst • 1 Reply 303 View • 2020-12-23 01:59:04
How to Parse KV Format(key=value) Excel Cells
-
blackduckie • Analyst • 1 Reply 368 View • 2020-12-22 09:49:25
Split an Excel Table by Time Interval and Expand It Horizontally
-
blackduckie • Analyst • 1 Reply 461 View • 2020-12-22 08:38:59
How to Split a Large Excel File into Smaller Files
-
blackduckie • Analyst • 1 Reply 383 View • 2020-12-15 10:55:49
Convert a Multi-row-based Table to a Regular Row-wise Table
-
blackduckie • Analyst • 1 Reply 324 View • 2020-12-14 01:17:30
Extend One Row to Multiple Rows by a Specific Rule
-
blackduckie • Analyst • 1 Reply 340 View • 2020-12-11 09:18:34
Group Excel Data and List Column Values Horizontally in Specific Order
-
blackduckie • Analyst • 1 Reply 1,334 View • 2020-12-08 11:53:50
Extract Data from a Specifically-patterned TXT File to Export to Excel
-
-
blackduckie • Analyst • 1 Reply 271 View • 2020-12-06 08:32:59
Directly Query Excel/Text Files Using SQL
-
blackduckie • Analyst • 1 Reply 370 View • 2020-12-04 09:21:54
Execute Excel-like Formulas outside Excel
-
blackduckie • Analyst • 1 Reply 346 View • 2020-12-04 08:37:33
Group & Summarize an XLS file without Using Excel
-
blackduckie • Analyst • 1 Reply 349 View • 2020-12-03 10:12:06
Get the Previous & Next Row of Same Group without Sorting the Excel Data
-
blackduckie • Analyst • 1 Reply 393 View • 2020-12-02 06:05:30
How to Use SQL to Query Data in Excel
-
-
blackduckie • Analyst • 1 Reply 387 View • 2020-11-12 07:30:55
Group & Summarize a Big Excel File Every N Rows
-
blackduckie • Analyst • 1 Reply 398 View • 2020-11-12 07:26:55
Dynamically Parse Expressions That Contain Cell Variables
-
blackduckie • Analyst • 1 Reply 390 View • 2020-11-12 07:24:31
Group & Summarize Excel Data with a Scripting Language
-
jinxing • Analyst • 18 View • 2024-05-17 09:29:02
In Excel, split each row of text in each group and calculate intersection
-
jinxing • Analyst • 27 View • 2024-05-16 10:03:20
In Excel, group & summarize data by header row without adding a helper column
-
jinxing • Analyst • 31 View • 2024-05-16 00:34:17
In Excel, count workdays in the intersection of multiple date intervals
-
jinxing • Analyst • 43 View • 2024-05-15 02:21:12
In Excel, generate a row using every N columns of data
-
Lina • Analyst • 71 View • 2024-05-11 02:04:07
Excel Number Records by Category and Intra-group with Sequence Numbers
-
Lina • Analyst • 64 View • 2024-05-10 01:56:26
Excel Row-to-column Transposition after Two-level Grouping
-