Enumlist to multiple rows

[Saketh_Dutch]

I have a table which has the details of the employees working on different projects and some other details as well. One project has multiple employees attached to it (Either 2 or 3 or 4 or even more). Now I want to create a new table which has a different row for every employee and all the other details remain same. PFB images for reference. Employee 3 has two projects allocated to him and thats why he has two rows.

[WillowMobileSys]

Actually, AppSheet has a feature built in to support this structure.  It requires the very easy step of establishing a relationship between the tables.  I refer to it as a "strongly coupled Parent Child" relationship.

To establish this in your table structure, in the Project Members (I'm assuming a name) table be sure the "Project" column is configured as a REF column to the Project table.  Then "turn on" the property "Is part of".  You will then want to remove the "Employee" column from your "Projects" table.

By making these simple adjustments, when you open the Projects Form to add or edit a Project, you will automatically be presented an Inline table on the Form where you can enter each Project Member.  Also, the Projects table will automatically be assigned a column named "Related Project Members" which will contains references to each member row that is part of THAT project.  Lastly, should you delete a Project, all Project Member rows will also automatically be deleted - which is why think of this as "strongly coupled".

Refer to the following article for details (scroll down to the "Express ownership between tables" section concerning the "Is part of" property)  - References between tables