Collect data from several lists base on user parameter

asked 2018-10-01 14:04:06 +0100

Hello. 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.

edit retag flag offensive close merge delete