Fill in SSN

Question

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.

test_data.xlsx

JagdeeshN · Accepted Answer

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 Answer

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

messi007 · Accepted Answer

@bvolles,

Please see below:

Attached the workflow,

Hope that helps,

Regards,