Groovy is going to be your best bet so you have full control over what you need to do. Outside of that, you could try using a datasource to read from the spreadsheet, groovy test step to manipulate the data however you desire, and then a data sink to write it back but at that point you might as well just write an entire groovy script to do what you want.
---
Click the Accept as Solution button if my answer has helped, and remember to give kudos where appropriate too!
