Hello,
we have on eexcel with 2 sheets like below.
In sheet 1 , suppose there are 2 users and those are tagged in 2 pojects(DC500,DC400) / 1 project(DC100) that data is there like below.
In sheet 2 unique data is there with no duplicate value with reference to sheet 1 , like below
my expected output is ,
first need to add two column like project key and total hours with keeping same data as sheet 2
then for each user need to check is he tagged in more than one project or not ,
if no then -
need to add data i column “worked” and write to “total hours” in new sheet , here rohit worked in only 1 project so in output sheet in 1 row data is there with woked column total in total hours
If yes then (worked more than 1 project)-
need to add that many rows for user with respect to projects and need count of worked intotal hours.
here kunal worked in 2 projects so count for first project for hours is 10+10 =20 and for second project is 2 so same mentiioned in output excel
how can i achieve this?
