Merging Rows Based on Shared Cell Data

Is there a function where you can combine rows of data on an Excel worksheet based on the condition/rule of them sharing the same data in certain cells?

See attachment for a basic example.

This is to be a formula or a function I can write into a macro so I want it to be something like "combine rows where cells in column E contain shared data" for example.


Thanks