Null values in the following rows

[spandana16]

Hello All,

I am new to the Alteryx and need some help. I have a situation where few rows in the column named "Both" are populated with value 'U,B' for the same person ID. But, I need to create a new column where I want the first row to be 'U,B' and the following rows to be null for the same person.

[jasperlch · Accepted solution]

@spandana16 

Not sure if below is exactly what you would like to achieve:

You could achieve this by using a Mulit-Row Formula:

[spandana16]

@Jasperlch

This is amazing. It worked like magic. Thank you so much :)