Hi Team,
I hope to seek your advice on how to archeive below flow:
I have data on grey header as below:
-This data has original name as AA/BB and CC/DD. They also have alternative names “Cat/ Dog/Orange/Apple” and “Cat/ Dog/Orange” accordingly.
-Each original name has certain date.
I want to make a flow to generate as 2nd picture below:
when the flow recognize the original name as AA/BB it will generate rows according to reach alternative name with same date.
(AA/BB will genenrate 4 rows with alternative name “Cat”, “Dog”, “Orange”, “Apple” and date as “Mon” in each row. Same to BB/CC)
Any method or suggestion to achieve this goal will be appreciated
Thank you so much.