Merging cells in specific multiple columns where column A values are the same

Hi,
I wonder if anyone can help me with this. I've tried looking online but am maybe struggling to phrase my problem correctly. I have a table with information about people, their computers and the applications on them. There is currently a row for every application with the other information repeated. I would like to merge the repeated cells so that it reads better but keep separate lines for each application. I've attached a workbook to try and explain it better. Sheet 1 is a sample of what I have and Sheet 2 is how I would like it to end up.

The workbook I need to actually run it on has a number of different sheets, some of which contain hundreds of machines.

Any help would be hugely appreciated.

Cheers

Not to worry, I found this which works for me.

Please Login or Register  to view this content.