#88 — String Concatenation And Aggregation

#programming #tutorial #beginners #productivity

Problem description & analysis:

There is a data table:

Task: Now we want to concatenate the ID numbers for each group of names by | to form a string, and put the result in column C (to calculate in cell C1).

Solution:

Use SPL XLL and enter the following code:

=spl("=E(?1).new(cum(~~+""|""+ID;Name):IDs)",A1:B13)The results are shown below:

Download esProc Desktop for FREE to optimize your data workflow!!! 🚀🔥⬇️

✨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

Hands-on debugging session: instrument, monitor, and fix

Join Lazar for a hands-on session where you’ll build it, break it, debug it, and fix it. You’ll set up Sentry, track errors, use Session Replay and Tracing, and leverage some good ol’ AI to find and fix issues fast.

RSVP here →