Forum

Split Column into l...
 
Notifications
Clear all

Split Column into lines and remove dublicated from neigbour column

3 Posts
2 Users
0 Reactions
103 Views
(@thenewbee)
Posts: 26
Eminent Member
Topic starter
 

Hello,

I try to tackle following challange:

 

I have an external list with a kind of "projects", where I asks different people for feedback.

In column "B" I have these people listed, and in column "C" I can see, from whom I got Feedback.

1.PNG

 

Now I need to figure out them, who are missing.

2.PNG

So in 5 of my 6 projects in total 10 missing feedback.

 

So the ideal result would look like this.

3-1.PNG

Until now I was only able, to split the origin column "B" into results and sort them into new lines.

But now I have no idea, how to proceed, and remove only them from my modified column "B", who is already listed in column "C"

 
Posted : 18/06/2021 4:45 am
(@mynda)
Posts: 4762
Member Admin
 

In the attached file I split the query into two: one for contacts and one for feedback. Then I merged them keeping only nulls. See query in file called 'Merge1' on the Trial sheet. Hope that's what you wanted. 

Mynda

 
Posted : 18/06/2021 8:33 pm
(@thenewbee)
Posts: 26
Eminent Member
Topic starter
 

Hello Treacy,

thanks you very much for that, it woks great 🙂

 
Posted : 22/06/2021 8:26 am
Share: