I’m looking for an automation to format one excel file to another excel layout.
Here is what I envision:
- Excel file saved to OneDrive folder as the trigger
- Then that file’s data is mapped to a new excel file layout as the action and saved in different OneDrive folder
Basically, Excel file with columns 1,2,3,4,5,6,7,8 automatically converted to an excel file with column 3 to column 1, column 2 to column 3, column 4 to column 7, etc.
I have Zaps that trigger on different events adding rows to existing excel spreadsheets, but this is more of a mass, One sheet layout to Another layout.
Thanks for any suggestions!!