Transpose Macro Needed (willing to donate to charity for quick answer!)

[Dazzawm]

I have sheet 1 with 2 columns, a number in A and a transmission in column B. I need the number and the transmission transposed onto sheet 2. There may be a unique number in A or several the same with different transmissions in B. In the example I have highlighted the duplicates in A. The yellow one has the same number in A but 3 transmissions in B so they will go under the transmission header in B (also yellow), the same with blue and orange.

Sheet A will consist of several hundred thousand rows so this is just a small example. Like I mentioned I would appreciate a quick solution on this one as it is for work so willing to donate to charity if needs be. Thanks.

Excel 2010
	A	B
1	Number	Transmission
2	10200362	MTM
3	10200363	MTM
4	10200364	MTM
5	10200364	ATM
6	10200364	CVT
7	10200365	MTM
8	10200365	ATM
9	10200366	MTM
10	10200371	MTM
11	10200371	SEMI
12	10200372	ATM
13	10200373	ATM
Sheet1

Sheet 2 after code.

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	ATM	ATM & CVT	ATM & CVT & MTM	ATM & CVT & MTM & Semi	ATM & CVT & Semi	ATM & MTM	ATM & MTM & Semi	ATM & Semi	CVT	CVT & MTM	CVT & MTM & Semi	CVT & Semi	MTM	MTM & Semi	Semi	Direct
2	10200372		10200364			10200365							10200362	10200371
3	10200373												10200363
Sheet2

 

[Dazzawm]

Thanks wideboy I think that's done it. My fault really I should have done 'remove duplicates' first.

PM me a favorite charity if you wish.

 

[wideboydixon]

Hey. It was an interesting exercise and I'm sure I'll re-use some of it in future so no worries. If you want to donate something then you can choose your favourite cause. If you really want me to nominate then I'd say these guys:

https://www.mndassociation.org/get-involved/donations/

WBD

 

[Dazzawm]

Done and thanks.