Group Rows Based on two values in a Column A

I'm trying to create a macro to group two rows but having a lot of trouble doing it. in total there about over 1,000 rows that im grouping.

Here a sample of wha I'm trying to do. If anyone can help that would be great becuase doing this manually is driving me nuts .


Book1.xls

Do you need to hide or get rid of the original rows? Or can they stay?

whichever is easier. I can always hide them after np.

Hope this helps.

Please Login or Register  to view this content.

This Works but i need the rows to stay and also have the plus on the side to open or hide when i chose.

is there anyway i can use.....Selection.Rows.Group
in this formula?

Try this:

Please Login or Register  to view this content.