This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
Problem description & analysis:
An Excel table has column titles, and there are certain empty cells.
For each row, concatenate column titles corresponding to the empty cells with slashes (/).
Solution:
Enter the following formula in SPL XLL:
=spl("=?.to(2,).(?(1)(~.pselect@a(!~)).concat($[/]))",A1:F8)
As shown in the picture below:
Explanation:
pselect()finds positions of members meeting the specified condition; by default, it returns the position of the first eligible member; @a option enables returning positions of all eligible members. to(2,) gets members of a sequence from the 2nd to the last.
The example was originally on StackOverflow. Feel free to check the conventional solutions and compare them with the SPL approach to get the efficiency of it!
For more FREE resources, please refer to the following links ⬇️:
SPL download address: esProc Desktop FREE Download
Plugin Installation Method: SPL XLL Installation and Configuration
References to other rich Excel operation cases: Desktop and Excel Data Processing Cases
YouTube FREE courses: SPL Programming
This content originally appeared on DEV Community and was authored by Judith-Excel-Sharing
Judith-Excel-Sharing | Sciencx (2024-09-04T02:53:48+00:00) #57 — Concatenate Column Titles Corresponding to Empty Cells. Retrieved from https://www.scien.cx/2024/09/04/57-concatenate-column-titles-corresponding-to-empty-cells/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.