How to add information in Google sheets between existing columns with information or formulas

My goal is to retrieve information from Woocommerce orders in Google Sheets in the way that data is placed between columns where there are formulas or data. Like in the screenshot.
How to achieve this? As far as I tried only way I got to append data at the bottom.

To get helpful responses

  • explain your goal with as much context as possible
  • mention any steps you’ve tried so far

Include screenshots of

  • your scenario setup (functions, mappings, variables, etc.)
  • module configurations and outputs
  • any error messages you are getting

Welcome to the Make community!

You’ll need to use a combination of “Search Rows” and “Update Row”.

Screenshot_2024-01-25_174727

2 Likes

Thank you very much for your advice!
Problem solved!:slight_smile:

2 Likes