Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

customized sorting macro

  Asked By: Ruben    Date: Oct 13    Category: MS Office    Views: 827
  

suppose i have data in the form;

cell_id ..........neighbour_ id

1 ............... 2
1 ............ 3
1 ............ ...4
2 ............ ...1
2 ............ ...3
3 ............ ...1
3 ............ ...2
3 ............ ...4

the input has 2 columns.

this is the output i am interested in:

cell_id neighbour_id1 neighbour_id2 neighbour_id3
1 ...........2 ...........3 ..........4
2 ...........1 ...........3
3 ...........1 ...........2 ..........4

can anyone help me .
ps note;there are 4 columns in the output.
Macro would be preferred or you can tell me using VBA.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on customized sorting macro Or get search suggestion and latest updates.




Tagged: