Sort range based on specific characters, Formula or VBA

[rmence]

Afternoon, this forum has been extremely helpful over the years... hope to find some help again.

I am trying sort a range of cells based on specific characters, it is hard to describe so let me post an example.

I want to turn this:

Real Pos	Name	Pos Sorted	Name Sorted
C	47531-80821:Jarrett Allen	PG
PG	47531-97018:Chris Chiozza	PG
PF	47531-81529:Daniel Theis	SG
SG	47531-84669:Luka Doncic	SG
PF	47531-84683:Jaren Jackson	SF
SF	47531-40199:Giannis Antetokounmpo	SF
SG	47531-16261:Khris Middleton	PF
PG	47531-67708:Dejounte Murray	PF
SF	47531-110347:Keldon Johnson	C
	0​
	0​
PG	47531-97018:Chris Chiozza	PG
SG	47531-84669:Luka Doncic	PG
PF	47531-20491:Robert Covington	SG
PF	47531-84683:Jaren Jackson	SG
SF	47531-40199:Giannis Antetokounmpo	SF
SG	47531-16261:Khris Middleton	SF
C	47531-58378:Jakob Poeltl	PF
PG	47531-67708:Dejounte Murray	PF
SF	47531-110347:Keldon Johnson	C
	0​
	0​

Into this:

Real Pos	Name	Pos Sorted	Name Sorted
C	47531-80821:Jarrett Allen	PG	47531-97018:Chris Chiozza
PG	47531-97018:Chris Chiozza	PG	47531-67708:Dejounte Murray
PF	47531-81529:Daniel Theis	SG	47531-84669:Luka Doncic
SG	47531-84669:Luka Doncic	SG	47531-16261:Khris Middleton
PF	47531-84683:Jaren Jackson	SF	47531-40199:Giannis Antetokounmpo
SF	47531-40199:Giannis Antetokounmpo	SF	47531-110347:Keldon Johnson
SG	47531-16261:Khris Middleton	PF	47531-81529:Daniel Theis
PG	47531-67708:Dejounte Murray	PF	47531-84683:Jaren Jackson
SF	47531-110347:Keldon Johnson	C	47531-80821:Jarrett Allen
	0​
	0​
PG	47531-97018:Chris Chiozza	PG	47531-97018:Chris Chiozza
SG	47531-84669:Luka Doncic	PG	47531-67708:Dejounte Murray
PF	47531-20491:Robert Covington	SG	47531-84669:Luka Doncic
PF	47531-84683:Jaren Jackson	SG	47531-16261:Khris Middleton
SF	47531-40199:Giannis Antetokounmpo	SF	47531-40199:Giannis Antetokounmpo
SG	47531-16261:Khris Middleton	SF	47531-110347:Keldon Johnson
C	47531-58378:Jakob Poeltl	PF	47531-20491:Robert Covington
PG	47531-67708:Dejounte Murray	PF	47531-84683:Jaren Jackson
SF	47531-110347:Keldon Johnson	C	47531-58378:Jakob Poeltl

So I would like to learn how to (thru formula or VBA) copy the B column to the D column based on the C column (in this case their basketball position). Trying formulas I am getting confused with the second "PG" etc etc. Also, I think I might have to learn more VBA because the sets of 9 go on for a while, sometimes hundreds... I only copied 2 from my opensolver output. Let me know if I need to elaborate... I am not sure if I am explaining myself thoroughly.

Any help or direction you folks can provide would be very sincerely appreciated.
Thanks.
-Rick

 

[MARK858]

Seeing as your sorted list doesn't appear to fit any normal sorting convention i.e. AlphaNumeric, Color etc. I think that you will probably have to look at doing a Custom Sort (I also can't see anything to distinguish the top half of your data from the bottom half).

Have a look at the link below for some basics on Custom Sorting...

Sort Data With Excel Custom Lists - Contextures Blog

You know how to sort an Excel list alphabetically, and with Excel 2007 you can even sort an Excel list by colour.

contexturesblog.com