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.
Solved! Go to 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