esProc Desktopesproc-desktop.hashnode.dev·8 hours ago#102 — Deduplication of Simple Data — Keeping the Original OrderProblem description & analysis: There is a data 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: Download esProc Desktop for ...10 likesexcelAdd a thoughtful commentNo comments yetBe the first to start the conversation.