A "create spreadsheet for each unique value" action for Excel.
Tom_177058 Posts: 4
Currently this action exists for tables and .CSV files, but not for .XLSX files. It would be a great addition to the action library!
Thanks for the feedback, @Tom_177058. While there is no direct way to accomplish this right now, our suggested workflow pattern is:
- Convert an .XLSX file to .CSV using the action Excel: Convert to CSV
- Use the action CSV: Create spreadsheet for each unique value