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

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

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!

2. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

try
``Please Login or Register  to view this content.``

3. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

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?

4. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

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

5. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

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

7. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

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!

8. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

See if this is what you wanted
``Please Login or Register  to view this content.``

9. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

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

10. ## Re: Match cells in column, then transpose matching row data from column b, c etc on many

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

There are currently 1 users browsing this thread. (0 members and 1 guests)