Hello.
I am new to Alteryx, and I have an excel file with one sheet, on that sheet are multiple columns each representing a different company, as well as three initial columns and row data that are applicable to all companies on the sheet.
Im trying to find a way to automatically extract each individual company column plus the 3 initial applicable columns, into separate worksheets for each company, with the column name extracted being made the file name.
Does anyone know if this is possible in alteryx apart from a column select tool approach which is way too manual.