Grouping muliple rows with same reference into single row

Hi,

I would like some help creating a macro to group multiple rows with the same reference into a single row.

In the first table is what I currently have and the second table is what I want to get to. I have also attached this example.

What I need is something to scan down column A and if it finds multiple instances of the same ref do:

1. insert a new row below and highlight it if possible and
2. copy the data from the above cells into the new row e.g. for Ref 011 below, there are 3 instances. The data in columns A, C and E is identical in each row so just copy that value once into the new row. The data in columns B and D are different so want all that data copied.

I would appreciate any help as this is beyond my capabilities.

Current table

Ref	Step 1	Step 2	Step 3	Step 4
007	Create Message with A indicator present	Feed message	Check for indicator A	Verify all details
008	Create Message with B indicator present	Feed message	Check for indicator B	Verify all details
008	Create Message with E indicator present	Feed message	Check for indicator E	Verify all details
010	Create Message with B indicator present	Feed message	Check for indicator B	Verify all details
011	Create Message with C indicator present	Feed message	Check for indicator C	Verify all details
011	Create Message with Z indicator present	Feed message	Check for indicator Z	Verify all details
011	Create Message with G indicator present	Feed message	Check for indicator G	Verify all details

Target table

Ref	Step 1	Step 2	Step 3	Step 4
007	Create Message with A indicator present	Feed message	Check for indicator A	Verify all details
008	Create Message with B indicator present	Feed message	Check for indicator B	Verify all details
008	Create Message with E indicator present	Feed message	Check for indicator E	Verify all details
008	Create Message with B indicator present Create Message with E indicator present	Feed message	Check for indicator B Check for indicator E	Verify all details
010	Create Message with B indicator present	Feed message	Check for indicator B	Verify all details
011	Create Message with C indicator present	Feed message	Check for indicator C	Verify all details
011	Create Message with Z indicator present	Feed message	Check for indicator Z	Verify all details
011	Create Message with G indicator present	Feed message	Check for indicator G	Verify all details
011	Create Message with C indicator present Create Message with Z indicator present Create Message with G indicator present	Feed message	Check for indicator C Check for indicator Z Check for indicator G	Verify all details