Grouping Projects Formula

[rwcg2d]

Hello, I have two columns:

Project - Include

I want to group all of the different projects based on the order they appear/are marked included (1,2,3,n).

How would I do this?

Example:[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Project1[/TD]
[TD]X[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Project1[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]Project1[/TD]
[TD]X[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Project2[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]Project3[/TD]
[TD]x[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Project3[/TD]
[TD]x[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

Hello,

Once the formula you are looking for is applied to your example ...

What would your expected result look like ...?

 

[rwcg2d]

The expected result is the third column listed.