Multiple Headers within data set

[thrnma]

Hello,

My data looks like the below

Birmingham

31-01-2021

29-01-2021

London

28-01-2021

27-01-2021

I would like the data to look like

Birmingham	31-01-2021
Birmingham	29-01-2021
London	28-01-2021
London	27-01-2021

Essentially using the headers as a new columns associated to each date within its section. I can think how to do it manually, but how would I replicate this in Alteryx. I'm looking at thousands of lines from about 40 cities, and will be doing this monthly. Thank you in advance!

Matt

[thrnma · Accepted solution]

I used a formula to create a new field

This made the data set look like the below:

Birmingham	Birmingham
	31-01-2021
	29-01-2021
London	London
	28-01-2021
	29-01-2021

Then, I used the link below, tweaking the formula to be looking for blanks ([Port] = '' instead of IsNull([Port]) as I had used a data cleansing tool to which made them blank, not null)

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-fill-down-with-last-non-null-va...

and this gave me the output of

Birmingham	Birmingham
Birmingham	31-01-2021
Birmingham	29-01-2021
London	London
London	28-01-2021
London	29-01-2021

[messi007 · Accepted solution]

@thrnma,

Please see below:

Attached the workflow,

If this solve the need please mark it as solved. It will help others.

Regards,