This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have two excel sheets with me, keys and Products (Sheets Name). Keys sheet contains ID field, and Products contains ParentID, DataCategoryGroupName and DataCategoryName. Id and ParentID are both same.
I need to find out those ParentID which exist only in Products sheets and I need unique values of ParentID, with DataCategoryName next to each other (in same column) seperated by "; "