Dates in the wrong column

Question

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!

screenshot3.PNG

RolandSchubert · Accepted Answer

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