Dear Alteryx,
I have a question related to data preparation. My excel file consist of project revenue data, grouped by customers and country.
The first column states the customer name, country name or project number.
Format wise, the country name has space between the start of the characters and the left cell border (1 time 'increase indent').
The project number has double the space between the start of the characters and the left cell border (2 times 'increase indent').
The customer name has no space between the start of the characters and the left cell border.
I would like to split the first column into 3 columns, 1 for company name, 1 for country name, 1 for project number.
Somehow Alteryx therefore needs to be able to read the cell format in order to identify the 3 different types (content starting directly or after 1 or 2 times space).
How can I do this with Alteryx / Excel?
Please find attached an example of how my data looks like.
Kind regards,
Koen
