Hi all,
I have sourced a file from a government website which has been formatted for consumer use. As a result, I get something like the left of the screenshot. I have managed to work it down to then right.
Does anyone know how to move the date so that the first column will be the date? Is this able to be replicated down the table?
i.e.
September 2013 New South Wales
September 2013 Victoria
September 2013 Queensland
September 2013 South Australia
September 2013 Western Australia
September 2013 Tasmania
etc.
Thanks!
Solved! Go to Solution.
Hi @ben7 ,
you can use a Multi-Row formula tool to achieve this.Formula has to check for NULL values in data columns as a flag for the period information and take this to populate a period field. I've attached a sample workflow
Best regards
Roland
Thanks!!!