DEV Community

Cover image for #99 — Deduplication of Simple Data
Judith-Excel-Sharing
Judith-Excel-Sharing

Posted on

2 1 1 1 1

#99 — Deduplication of Simple Data

Problem description & analysis:

There is a data table:

source table
Task: We want to duplicate the data.

Solution:

Use SPL XLL and enter the following formula:

=spl("=?1.id()",A2:A17)

result table


Download esProc Desktop for FREE and enhance Excel’s capabilities!! 🚀🔥⬇️

✨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

Image of Wix Studio

2025: Your year to build apps that sell

Dive into hands-on resources and actionable strategies designed to help you build and sell apps on the Wix App Market.

Get started

Top comments (1)

Collapse
 
judith677 profile image
Judith-Excel-Sharing

Feel free to share your thoughts with the communities!

🥳Discord
🥳Reddit

👋 Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay