Forum Discussion

RajHelaiya's avatar
Qrew Captain
5 years ago

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
No RepliesBe the first to reply