Hi Peter, thanks for reaching out!
To help, hereβs an example demonstrating how to pivot data between tables using a Lookup integration. It works similarly to the VLOOKUP function in Excel: Watch the video, which should address the use case you're describing here.
You can also find more details about this feature in our documentation.
Let me know if you have any questions!