Hi Team,
Can someone please help me with the below solution?
There are 3 sheets in the attached excel file. Data 1, Data 2, Output in Data 2.
I want to process information from Data 1 and Data 2 and the output should be in Data 2 sheet as indicated in "Output in Data 2" sheet. Thanks in advance!
Solved! Go to Solution.
Hi @PrashantJP ,
this was achieved by a bit of transpose magic:
Workflow attached.
I hope this helps.
M.
Hi @PrashantJP,
You could achieve a HLOOKUP equivalent with a transpose and join:
I've attached my workflow for you to download if needed!
Kind regards,
Jonathan
Hi @PrashantJP
Here is a workflow for the task.
1. Using sample tool to get last row.
2. Using transpose tool to convert rows to columns.
3. Using Find & Replace to do a Vlookup. Link
Hope this helps 🙂