Problem description & analysis:
Here is a categorized detail table:
We need to group the table and concatenate the detail data using the semicolon.
Solution:
Use SPL XLL to do this:
=spl("=E@b(?.groups(~1;concat(~2;$[;])))",A2:B9)
As shown in the picture below:
Explanation:
E@b function converts the two-dimensional table to a sequence. ~1 represents the first sub-member of the current member; and $[] represents a string.
Top comments (2)
Please free to download it and explore the data processing journey on your own⬇️
SPL download address: scudata.com/download-Desktop
Plugin Installation Method: c.scudata.com/article/1652061135502
References to other rich Excel operation cases: c.raqsoft.com/article/1651916536524
SPL Programming (YouTube FREE courses): youtube.com/playlist?list=PLQeR-Ih...
Some comments may only be visible to logged-in visitors. Sign in to view all comments.