I have a excel sheet which has few columns like Emp name, Proj ID, Manager name, Project name, Start date, End date
One emp name is associated with more than one project and also one manager would be associated with multiple projects.
How do i extract for each emp all his unique Proj IDs, project names, start date and end date
Also for each manger : his unique Proj IDs, Project Names, start date and end date
In the above image, For Eg: Kevin name is found on 2 rows, So i need to extract
Project Names(ABC-1, ABC-2) , Project IDS(P1 and P1), Start dates and end dates for Kevin
it is a group by case and can be implemented as described in the link shared above
With your input: Project Names(ABC-1, ABC-2) , Project IDS(P1 and P1) we do have a requirement of concatening the group member values (PName, PIDs)
about the start date there is no requirment given. it could be the case to use the lowest startdate of the kevin projects and the latest End date for the kevon projects in the case of Kevin. But as it is an assumption we would prefer to have all definitons together before we start
Can anyone please help me to copy the following datatable to email.
I want to exclude the 1st row (column0, column1…) in the email. Also i need to copy columns from 0 to 7 only