I've got data that is pulling in from an excel sheet that has merged columns, which obviously Alteryx does not like! I was wondering if there was a way to easily tag the data using Alteryx without having to change the underlying spreadsheet template.
Here's an example of the excel sheet:
In Alteryx, I want to be able to show that the Proceeds, Cost and Gain/(Loss) columns all relate to Ordinary Shares and Fund IV. On the excel, the number of funds will change so this needs to be dynamic and they're always next to each other. The columns for Proceeds, Cost, Gain/(Loss) all have numbers in the rows below them.