Analyst •
294 Reference •
196 Reply •
1 Follow
Follow
Default
Hot
Nice
Preferred
Recent reply
excel(109) transpose(9) grouping(8) distinct(3) sql(3) data rearrangement(3) conditional grouping(3) difference operation(3) caculate(2) date handling(2) spl xll practice(2) concateantion(1) json(1) column-wise storage(1) spl desktop practice(1)
excel(109) transpose(9) grouping(8) distinct(3) sql(3) data rearrangement(3) conditional grouping(3) difference operation(3) caculate(2) date handling(2) spl xll practice(2) concateantion(1) json(1) column-wise storage(1) spl desktop practice(1)
-
Lina • Analyst • 104 View • 2024-04-10 02:11:06
Excel Get Common Words of Comma-separated Word Strings
-
Lina • Analyst • 119 View • 2024-04-09 01:43:17
Excel Auto-delete Empty Detailed Rows after Grouping
-
Lina • Analyst • 327 View • 2024-04-08 02:00:51
Excel Write All Values of the Non-Grouping Field in One Row
-
Lina • Analyst • 126 View • 2024-04-07 05:10:33
Excel Sort a Certain Column according to the Specific Order of Key Words It Contains
-
Lina • Analyst • 121 View • 2024-04-03 02:00:41
Excel Group Rows and Concatenate Each Value of a Specific Column into a String
-
-
-
-
-
mars • Analyst • 1 Reply 278 View • 2023-12-14 03:35:00
SPL Desktop Practice: How to Quickly Split an Excel into Multiple Excels
-
mars • Analyst • 1 Reply 260 View • 2023-11-30 08:22:18
SPL XLL Practice: Excel Interval Association
-
mars • Analyst • 1 Reply 263 View • 2023-11-23 12:35:36
How to do Excel table association – You are out if you know only VLOOKUP
-
mars • Analyst • 1 Reply 293 View • 2023-11-30 08:20:31
SPL XLL Practice: Almighty Text Splitting in Excel
-
mars • Analyst • 1 Reply 343 View • 2023-11-20 08:22:19
Set operations of Excel inter row data (intersection, union, difference)
-
mars • Analyst • 1 Reply 436 View • 2023-11-20 08:22:28
Set operations of data between Excel columns (intersection, union, difference)
-
-
mars • Analyst • 1 Reply 284 View • 2023-11-20 08:22:47
How to automatically extract eligible rows in Excel
-
-
mars • Analyst • 1 Reply 325 View • 2023-08-31 10:34:05
Batch summary of multiple Excel spreadsheet data – done in 1 minute
-
-
blackduckie • Analyst • 355 View • 2021-07-19 06:02:34
Check Whether There Are Missing Time Points in a Certain Interval
-
-
blackduckie • Analyst • 1 Reply 1,133 View • 2021-01-27 07:20:04
How to Convert a Grouped Excel File That Contains Merged Cells into JSON Format
-
blackduckie • Analyst • 1 Reply 340 View • 2021-01-14 08:12:14
How to Group & Sort Column Values Automatically
-
blackduckie • Analyst • 1 Reply 447 View • 2020-11-11 09:27:48
Get Values from Same Group by Relative Position in Excel