Generate new row and copy data from specified row above based on condition

[snwk]

Hi guys, I'm new to Alteryx and couldn't figure out a way how to do this, maybe someone can help.

I have an input table that looks like the following:

Location (header)

Berlin

Berlin

Munich

Munich

London

London

I'd like to generate a new row whenever there's a new location (active row does not equal row -1) and copy the data from the first row (header). The Output should look like this:

Location

Berlin

Berlin

Location

Munich

Munich

Location

London

London

It would also be necessary to save every location in a new excel sheet (within the same workbook). 

Thanks and kind regards!

[ShankerV]

Hi @snwk 

Step 7: Filter tool

Step 8:

Expected output:

Many thanks

Shanker V

[BS_THE_ANALYST]

One way to rearrange the data:

From this:

to this

The workflow depends on the header being called 'Location' though. If you change it, the workflow will prompt you to tick the boxes for the new header name. 

[snwk]

Thank you, it worked!!

[BS_THE_ANALYST · Accepted solution]

@snwk I've made the solution dynamic now - thanks to @ShankerV 's workflow/logic. You can select whatever column name you like, and aslong as there's a subheading, this workflow will arrange your data into groups (they may be mixed up i.e. London, Berlin, London, London), then output what you required. 

Thanks for the question, this was a great learning for me! 😀

[ShankerV]

Hi @BS_THE_ANALYST 

Thanks. Good to know my workflow/logic helped you too....