#87 — Merge Data of The Same Group

#productivity #beginners #programming #tutorial

Problem description & analysis:

Here below is an annual and quarterly sales data table:

Task: In this table, column A is ordered and has duplicate values. Now we want to clear the data from all rows in the same group except the first row.

Solution:

Use SPL XLL and the code is as follows:

=spl("=E(?1).group(#1).(~.run(if(#==1,,#1=null))).conj()",A1:C21)

The results are shown below:

Download esProc Desktop for FREE and make Excel work smarter for you!!! 🚀🔥⬇️

✨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

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more