Duplicating certain fields based on a cells content

Hi all,

I'm having an issue with a third party product where multiple instances of a name shows up but only 1 email address field populates. To accurately collect the data I need all the email fields to be filled in. Is there a tool that can help fill in the blanks based on one name field already having an email associated with it?

Dataset

Desired Result

Thanks!

Output

Accepted answers

A multi-row tool would be able to do it.

Assuming the fields are all sorted and ordered like this, you can use the tool to update your Email field with a formula like

if isempty([Email]) and [Name] = [Row-1:Name] then [Row-1:Email] else [Email] endif

All comments

A multi-row tool would be able to do it.

Assuming the fields are all sorted and ordered like this, you can use the tool to update your Email field with a formula like

if isempty([Email]) and [Name] = [Row-1:Name] then [Row-1:Email] else [Email] endif

@jwlam Another method using summarise and join tool

Join_240423.yxmd

@SPetrie Worked perfectly. Thanks!!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703