Excel - combining rows of data

I need help with merging multipul rows in excel, I need rows by the same name and date to merge together into one line joining the tasks done into one row (date).

currently I am manually merging around 1000 rows of data.

please see example below.

Solution 1:

Try to use Power Query:

Select the Range- go to Data- Get & Transform Data- From Sheet- open Power Query Editor- select Columns Task 1- Task 6- go to Transform- select Unpivot Columns- Select Attribute column- under Transform Tab select Pivot Column- Value Column select Value- Advanced option select Sum- change the Date format and close and load to...