Need help looking up multiple values

[HabsFan89]

The attached spreadsheet shows data in columns A:C for 2 processes that we repeat numerous times. Column A shows which iteration we are on, Column B shows which process is being used, and column C shows which constraints we came across in the process.

We run the same processes in each iteration, but in each iteration we can come across different constraints. I need to find a way to look up all of the constraints for each process regardless of the iteration. Columns F through P kind of shows what the output that I need. It doesn't have to look exactly like that, but I do need each process to have all of it's constraints listed next to it some how.

Can anyone help me with the formula for this?

Thank you!

[DBY]

Hello
As you only need to see a list of constraints for each process, have you considered using a simple Pivot table? See attached for an example.

DBY

[HabsFan89]

I have tried using pivot tables, but unfortunately it doesn't put that in a format that's easy for me to use. Once I figure out how to list my constraints out, I have to be able to separate those constraints out even further. I used a very simple example to illustrate my problem, but in reality, the pivot table doesn't really help me much. If I could figure out how to do it and list the constraints how like how my example showed, it'd make my life a lot easier.

Thanks for the help though!