Hi community.
I am used to google sheets but a friend asked me to create an automation where a new xls sheet was created from a master xls sheet which has 13,000 rows of customer records in it.
Every month approx. 20-50 of the customers place an order and this is entered into a column in the main sheet.
I need an automation which only extracts those customer records (rows) where an order has been placed and maps them to a new xls sheet.
I am not familiar at all with One drive and MS modules in make and cannot see an obvious way to do this. The attached screen grabs show the data from the main sheet which appears to have its data bundles with multiple collections per record. I can map the columns I want to a new sheet but do not know how to search the rows of the main sheet and only GET the rows with an entry in column AS (which, for added complexity, have a date of the current month ‘NOW’).