Transforming a Google Sheet

Hello! I’m very new to Make.com, but I’ve been working at tranforming some data in a google sheet. In essence I’m trying to figure out the logic and mapping to transform the first image into the second for a bunch of records.

Any ideas?

(First Image)

(Second Image)

Please provide the link to the example sheet so that we can build a test scenario for it.

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

Hi Samliew! Thank you for the response! I prepared a link to the sample sheet: Make.com Trial - Google Sheets