Defining row fields as a value until it reaches a certain value

[danielstefanng]

Hi,

I have the following data set below:

File Name 1A	File Name 1B
x	x
x	x
x	x
x	x
x	x
x	x
x	x
File Name 2A	File Name 2B
x	x
x	x
x	x
File Name 3A	File Name 3B
x	x
x	x
x	x

and would like to transform it to look like this:

COLUMN 1	COLUMN 2
File Name 1A	File Name 1B
File Name 1A	File Name 1B
File Name 1A	File Name 1B
File Name 1A	File Name 1B
File Name 1A	File Name 1B
File Name 1A	File Name 1B
File Name 1A	File Name 1B
File Name 1A	File Name 1B
File Name 2A	File Name 2B
File Name 2A	File Name 2B
File Name 2A	File Name 2B
File Name 2A	File Name 2B
File Name 3A	File Name 3B
File Name 3A	File Name 3B
File Name 3A	File Name 3B
File Name 3A	File Name 3B

Basically, change all the x's to 'File Name XX' when it hits a new 'File Name XX' value.

Thanks for your assistance.

Kind regards,

Daniel

[danielstefanng · Accepted solution]

Sorry no worries, this article solved my issue:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-fill-down-values-from-x-number-...

Thanks,

Daniel