I have a list with data with marked columns that assign them to a different group. On different sheets I would like have the different groups extaxted from the original sheet in a way that it automatically updates when I edit the original worksheet
Example
Result Worksheet 1Data group 1 group 2 group 3 1 x x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x
1
3
6
8
Result Worksheet 2
1
4
7
10
Result Worksheet 3
2
5
9
I haven’t found a way without having empty rows in the table
Thanks
E.
Bookmarks