Match cells in column, then transpose matching row data from column b, c etc on many tabs

The link

http://www.excelforum.com/excel-prog...b-c-d-etc.html

has good code which works for me (thanks tigeravatar). I have a workbook with a number of tabs, and I want to apply the code to each tab in one shot. I have no idea about programming, so any help appreciated!

try

Please Login or Register  to view this content.

Many thanks for your solution, which seems very elegant.

(1) I tested it with two tabs, each tab has two columns of data, works great. Is it possible to have the results eliminate the redundant rows?

So if I have:
1 a
1 b
2 a
2 c
2 d

I currently get

1 a b
1
2 a c d
2
2

(3) I have some tabs with more than two columns of data (there is no set rule as to how many columns there might be). Will it work with this?

Need to see the data and the result that you want.

Sure, I am attaching an example of a multi tab, multi-column-in-tab sheet that I am hoping to sort in the way described

What is your desired result?

So if I have:
1 a
1 b
1 c
2 a
2 c
2 d

I would like to get

1 a b c
2 a c d

Same with multicolumn. if I have

1 a b
1 c d
2 e f
2 g h

Would like to get

1 a b c d
2 e f g h

Really appreciate this!

See if this is what you wanted

Please Login or Register  to view this content.

That is great. Many thanks.

Is it possible to remove the redundant rows as in my example? At the moment:

1 a
1 b
1 c
2 a
2 c
2 d

Turns into

1 a b c
1
2 a c d
2
2

I would like to get to

1 a b
2 a c d

Actually, the code still seems to be cutting off some of the data. See the attached before and after examples