Fill in SSN

[bvolles]

Hello all,

I have a data set with SSN and demographic data for people on a plan.  In most cases its a subscriber and dependents.  The dependents all have different SSN but I need to fill in the Subscriber SSN.  I have a fake data set attached and the cells in yellow I need the Subscriber SSN essentially to fill down until the next new value.  In my dataset I would need A2 to populate to A5 then A6 to populate to A10.  Any guidance would be appreciated.

[JagdeeshN · Accepted solution]

Hi @bvolles ,

A multirow Formula should do this for you.

Please find attached an example with the file you had provided.

Hope this helps.

Best,

Jagdeesh

[echuong1 · Accepted solution]

You can use a multi-row formula to essentially "drag down" the values until the hit the next populated one!

[messi007 · Accepted solution]

@bvolles,

Please see below:

Attached the workflow,

Hope that helps,

Regards,

[bvolles]

Thank you all very much it worked perfectly!

[JagdeeshN]

@bvolles 

Awesome!