Sort into Groups

[Tofox2]

Hi Everyone,


I'm looking for a formula or VBA code that will allow me to sort the following data:

Col A Col B


1
3


2




3
5


4




5
3


6
6


7 1

Into specific groups like the below.


Col A Col B


1 1



2




3 3
3


4




5 5



6 6



7

 

[Peter_SSs]

I'm not sure we can tell the correct layout of your data from that post. Could you use one of the methods linked from my signature block below to post the sample and expected results in a way we can be sure we have the data in the correct columns/rows?