Collect data from several lists base on user parameter

I have a little question probably because my english is not good enough to search for it. Sorry about that.
I’m looking for solution that lets to collect data from some lists from the same file into new list. Here’s an example:

List 1:
1 - a
2 - b
3 - c

List 2:
1 - d
2 - e
3 - f

I want to collect data from raws start with 1 and form a table on list 3 with content:

List 3:
1 - a
1 - d

I googled about something called pivot table but not sure it’s the thing i’m looking for.
Thanks in advance.