Match rows and columns - Join or Union?

[maxtla]

Hi,

Need your help.

I have 2 files, with different information.

But I need that the ID should be one with all fields. So one ID with the whole data from both rows.

One row for 375598 and another row with 462256.

I used join and union, but still 2 rows with the same ID...and I need to mix the information in the empty fields to create only one row.

Any help will be high appreciated!

M

[Qiu]

@maxtla 
We can use Transpose and CrossTab for this case.
In between we can filter out the Null values.

[DataNath · Accepted solution]

Is this the result you're hoping for? In the Cross-Tab tool we can concatenate the incoming fields which will combine cells with values with the nulls to just create the populated entry.

[maxtla]

Thank you for your response...was exactly what I need. Thx