How to Macro for reorganizing

[Lsxtrkiller]

I am looking for a macro to reorganize my data as follows:

For every Matching value in B I want to copy its adjacent A value and place them all into a Horizontal Setup. This example is a little hard to read but im having difficulty attaching snips and the template file.

Any help would be appreciated.

Example Input:

http://imgur.com/g9heOUN

Part No Fixt Group
49013 2
24157 2
448010 3
22937 3
51123 3
22952 6
22957 11
448957 11
22959 13
448675 13
51715 13
448606 13
22960 14
456062 14
448605 14
51644 14
22935 14
22962 15
448658 15
22963 16
448659 16
49559 17
23000 17
23002 18
49556 18
49736 19
23004 19
23005 20

Example Output:

http://i.imgur.com/pDVIAQe.jpg


Fixt Group Part No Part No Part No Part No Part No Part No
2 49013 24157
3 448010 22937 51123
6 22952
11 22957 448957
13 22959 448675 51715 448606


In which Fix Group is in column K for example and every part that belongs to that fixt group is in L:X if necessary.

Fix.xlsx

[Lsxtrkiller]

I will attach a sample workbook when I get home.

[Lsxtrkiller]

Sample workbook attached.

[jindon]

Try

Please Login or Register  to view this content.