I will admit I like to figure stuff out on my own through trial and error, however, I am struggling with this one. I think it's best if I provide a little more context about what I'm actually trying to do.
This is all about personalisation blocks in the template and where a value equals something they get a particular block in priority order, top down. Those values are coming through in a file, where a contact has duplicate rows and on each of those rows is a score. As discussed previously I want to pick up the top three scores, however, that leaves me with three rows per contact. I need to then transpose those values from a column to a row so that I can pass through one row per contact. This is why I was initially looking at using a function.