Populate column with conditional values

[Ciaran]

Hey guys,

Feel like this should be simple but haven't been able to make it work for me. Have a single column of data:

Column A

Title 1

data

data2

data3

Title 2

data4

data5

Title 3

data 6

data 7

data 8

data 9

And I want to take the Title and insert as a second column beside each data, like so:

Column A	Column B
Title 1	Title 1
data	Title 1
data2	Title 1
data3	Title 1
Title 2	Title 2
data4	Title 2
data5	Title 2
Title 3	Title 3
data 6	Title 3
data 7	Title 3
data 8	Title 3
data 9	Title 3

Appreciate any help. Thanks.

[Nick-C · Accepted solution]

Hey @Ciaran ,

Looks like a multi-row formula is what you're after, something like this should work:

IF
STartsWith([Col A],"Title") THEN [Col A]
ELSE [Row-1:New Field]
ENDIF

In the config make sure you're setting it as a string field! 

Please remember to accept as a solution if this works! 

[Emmanuel_G]

Hi @Ciaran ,

One way to do it easily

[binu_acs]

@Ciaran Another way of doing this

[Ciaran]

Thanks Nick, that worked perfectly for me!