Output

[aparna0208]

Hi,

I'm trying to organize final output and not sure how to do it. The output is as below after I join data where I get multiple rows for each record but I need it all in one row. Thank you in advance!

ID                   Name              City              State

1234               George           Null               CO

1234               George           Denver          Null

Expected output

ID                     Name                  City                   State

1234                 George               Denver              CO

[MarqueeCrew]

If your data is that reliable:

Summarize tool:

 group by id 

Max for each column of data. 

otherwise you can use a multi-row formula.  

cheers,

 mark

[amruthas2]

Hi @aparna0208 

You can summarize it when the input always have null values with other genuine value. 

[atcodedog05]

Hi @aparna0208 

My method would be same as above. Just few quick tips.

You can select multiple columns at a time by using ctrl key and select each column or using shift key select the top and then bottom like below. This will reduce the work of selecting each at a time.

You can easily rename all columns which have Max_ as a prefix in a select tool by selecting multiple columns and selecting option like below.

Another method is by using dynamic rename like below

Hope this helps : )