How can I join columns while keeping empty rows?

[Jun]

Hi,

Does anyone know how to join column of different sheets without deleting empty rows from the output?

For example, in sheet1 there is a data of 10 students' first names and their student IDs. Then in sheet2 there is data of 5 students' surnames and their student IDs.

If I use "joint" tool to join the sheet based on IDs, the output only displays the 5 students who exist in both sheet. But I want to keep the data of the remaining 5 students whose surname does not exist in sheet2.

Any help is appreciated. 

[fmvizcaino · Accepted solution]

Hi @Jun ,

You need to use a union tool right after your join to get data from more than one join output anchor.

Best,

Fernando Vizcaino

[Jun]

@fmvizcaino

Thanks a lot, solved my problem immediately.

It was a great help.

Regards,