Adding different rows for table with relationship in an export
Hello, I have a 2 tables- Resources (stores employee name and type)
Project entry- stores the projects that are worked on with date, and work hours field. There is a drop down called Projects, values of which come from a different table.
You can choose a resource and add project entries for them by selecting projects and adding work hours. There are 8 project entry drop downs.
When I try to export the Project entry table, it lists all the 8 projects in one single row in excel. I need to have one row for each project.
For example: If person A does 3 projects in a week, they need to be listed in different rows rather than the same row in the export file. Is there any way to achieve this with formulas or report building?
------------------------------
Raj Helaiya
------------------------------
Project entry- stores the projects that are worked on with date, and work hours field. There is a drop down called Projects, values of which come from a different table.
You can choose a resource and add project entries for them by selecting projects and adding work hours. There are 8 project entry drop downs.
When I try to export the Project entry table, it lists all the 8 projects in one single row in excel. I need to have one row for each project.
For example: If person A does 3 projects in a week, they need to be listed in different rows rather than the same row in the export file. Is there any way to achieve this with formulas or report building?
------------------------------
Raj Helaiya
------------------------------
