I was hoping to find the formula necessary for taking a table of values, and then creating new tables based on the paramters. Here is an example of the original table

X Y Z
1 2 4
2 4 5
1 1 6
2 3 2

I was hoping to then create a unique table for each X-Value somewhere else on the sheet eg:

x = 1

X Y Z
1 2 4
1 1 6

and

x =2

X Y Z
2 4 5
2 3 2

Is there a way to automate the creation of these secondary tables?

Thanks alot