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.
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |