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

Data	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
Result Worksheet 1

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.