Inner join but with messy raw data

Hello, please find attached excel with raw data and the output i needed.
raw data is messy, can you help with the workflow?
the raw data is just a sample, the original raw data is with more rows but similar format

Inner Join.xlsx (20.8 KB)

Why would a regular Joiner and Row Filter not work here…?

Hello @Aswin

In tab sheet “original file”, may i know how to add a new column and input the date?


Ah, only now I understand your problem. I will have to think about it :slightly_smiling_face:. My first thought is to use a Recursive Loop, but that will be slow and quite complex…