create a table with certain number of items in the group

yj1111 — Tue, 09 Jul 2024 06:25:48 GMT

Hi all,

I have the data sets as follows:

Project Name Needed Resource

Project A Resource A

Project A Resource B

Project A Resource C

Project A Resource D

Project B Resource A

Project B Resource B

Project C Resource A

Project C Resource B

Project C Resource D

Project D Resource B

Project D Resource C

Project D Resource D

Project D Resource E

Project E Resource A

Project E Resource B

project E Resource E

I want to set a parameter, when parameter is 2, the result is as follows:

Project Name with same resource group (resource number in the group =2) Resource Group

Project A, Project B, Project C, Project E Resource A,B

Project A, Project D Resource B,C

Project A, Project C Resource A,D

Project A, Project C, Project D Resource B,D

Project D, Project E Resource B,E

And I also want to create the table for resource number in the group =3,4,5,6...

Does anyone who know how to do it? Thanks in advance!

Re: create a table with certain number of items in the group

lbendlin — Fri, 12 Jul 2024 00:57:19 GMT

You are likely better off using a graphical solution.