DEV Community

Cover image for #102 — Deduplication of Simple Data — Keeping the Original Order
Judith-Data-Processing-Hacks
Judith-Data-Processing-Hacks

Posted on

2 1 1 1 1

#102 — Deduplication of Simple Data — Keeping the Original Order

Problem description & analysis:

There is a data table:

source table

Task: Duplicate the data and keep the original order.

Solution:

Use SPL XLL and enter the following formula:
=spl("=?1.id@u()",A2:A17)

The results are as follows:

result table


Download esProc Desktop for FREE and take your data analysis skills to the next level!!!! 🚀🔥⬇️

✨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

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up

Top comments (1)

Collapse
 
judith677 profile image
Judith-Data-Processing-Hacks

Data enthusiasts and business professionals, welcome to join our communities!

🌟Discord
🌟Reddit

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs