Cutting and Pasting Rows Based on a Matching Criteria

[LukeAJN]

Hi All

I have a particular problem here that I am wondering if anyone can figure out the best way to go about it. I currently have a spreadsheet with a jumbled and out of order list of values in a certain column. I need to be able to search the spreadsheet, find the two corresponding entries, and then cut and paste them so that they are in rows next to each other. The data is already sorted largest to smallest so when cutting a row it must always best inserted below the corresponding entries.


A small visualization of this would be like the below

COL B

X1

Y2

Z1

Y1

Z2

X2

This would then become

COL B

X1

X2

Y2

Y1

Z1

X2

 

[Bosquedeguate]

Are the values in column B as simple as the ones you used in your example. That is could the search be done only on the first letter of the value in Column B?

 

[LukeAJN]

No unfortunately not, in reality they are a number about 8 digits long, I just simplified it to make the code easier in this example. I should be able to manipulate it to give me what I want though

 

[Bosquedeguate]

So,

No unfortunately not, in reality they are a number about 8 digits long, I just simplified it to make the code easier in this example. I should be able to manipulate it to give me what I want though

you need to define “corresponding” will the values always be [A-Z]*nnnnn? (Letters before a numeric value?)

 

[LukeAJN]

So,

you need to define “corresponding” will the values always be [A-Z]*nnnnn? (Letters before a numeric value?)

In the actual excel there are no letters. 43277679 will always be matched with 00100345, 43780097 will always be match with 43226788 etc

 

[Bosquedeguate]

In the actual excel there are no letters. 43277679 will always be matched with 00100345, 43780097 will always be match with 43226788 etc

This is even more unclear ...
Can you you send a mini-sheet (XL2BB) with some of your sample data?

 

[LukeAJN]

Yes I will try send it later when I get home, I can't use that add on with my work PC. In reality these are account numbers, and every account has one opposite account. Think about how someone will have a personal/checking account and also a saving account with the same bank. The account numbers would be different but they need to be mapped together. I understand it is more complicated expressed this way, which is why in my first example I expressed it where the Xs get matched together, as do the Ys etc

 

[Peter_SSs]

which is why in my first example I expressed it where the Xs get matched together, as do the Ys etc

Except that it was Z1 and X2 at the end.

 

[LukeAJN]

Except that it was Z1 and X2 at the end.

View attachment 96933

Apologies, this was a typo that I seemed to miss, it should be Z1, Z2 at the bottom

 

[Bosquedeguate]

If your worksheet is sorted and the values are always paired together what is left to be done? I would think a sort on two columns would yield your desired results.