Multiple Headers within data set

Question

Hello,

My data looks like the below

Birmingham

31-01-202129-01-2021London28-01-202127-01-2021

I would like the data to look like

Birmingham

31-01-2021Birmingham29-01-2021London28-01-2021London27-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 Answer

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-2021LondonLondon 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-value-above-in-a-field/td-p/524783

and this gave me the output of

Birmingham

BirminghamBirmingham

31-01-2021Birmingham29-01-2021LondonLondonLondon28-01-2021London29-01-2021

messi007 · Accepted Answer

@thrnma,

Please see below:

Attached the workflow,

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

Regards,