How can I sort Individual Rows A to Z from Column I to Column DX with 3 Columns Groups Together (Name, Price and Stock)

[Goodluckboss]

Hi guys, I have an issue.

For some reasons, when I pull data from the source, the variations (options) name will keep moving between different columns so it is hard for me to keep track of the change in stock level

I have attached an excel spreadsheet with data for reference. How can I run a VBA to sort each individual row so that it sorts A to Z so that each column will have the SAME variation name

It starts from Column I and ends at Column DX and the Name, Price and Stock must move together as they are for that option name.

Thank you

Test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX
1	date	name	asin	minprice	maxprice	stock	total_sales	monthly_sales	o0_name	o0_price	o0_stock	o1_name	o1_price	o1_stock	o2_name	o2_price	o2_stock	o3_name	o3_price	o3_stock	o4_name	o4_price	o4_stock	o5_name	o5_price	o5_stock	o6_name	o6_price	o6_stock	o7_name	o7_price	o7_stock	o8_name	o8_price	o8_stock	o9_name	o9_price	o9_stock	o10_name	o10_price	o10_stock	o11_name	o11_price	o11_stock	o12_name	o12_price	o12_stock	o13_name	o13_price	o13_stock	o14_name	o14_price	o14_stock	o15_name	o15_price	o15_stock	o16_name	o16_price	o16_stock	o17_name	o17_price	o17_stock	o18_name	o18_price	o18_stock	o19_name	o19_price	o19_stock	o20_name	o20_price	o20_stock	o21_name	o21_price	o21_stock	o22_name	o22_price	o22_stock	o23_name	o23_price	o23_stock	o24_name	o24_price	o24_stock	o25_name	o25_price	o25_stock	o26_name	o26_price	o26_stock	o27_name	o27_price	o27_stock	o28_name	o28_price	o28_stock	o29_name	o29_price	o29_stock	o30_name	o30_price	o30_stock	o31_name	o31_price	o31_stock	o32_name	o32_price	o32_stock	o33_name	o33_price	o33_stock	o34_name	o34_price	o34_stock	o35_name	o35_price	o35_stock	o36_name	o36_price	o36_stock	o37_name	o37_price	o37_stock	o38_name	o38_price	o38_stock	o39_name	o39_price	o39_stock
2	31/05/2022 23:15:05	Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman	ABC	0.85	5.94	25236	5110	546	Cream,36-37(Fit 35-36)	5.94	972	Navy,44-45(Fit 43-44)	5.94	961	Pink,40-41(Fit 39-40)	5.94	962	Shoe brush,36-37(Fit 35-36)	0.85	989	Shoe brush,40-41(Fit 39-40)	5.95	0	Grey,42-43(Fit 41-42)	5.94	949	Cream,44-45(Fit 43-44)	5.95	0	Shoe brush,42-43(Fit 41-42)	5.95	0	Yellow,42-43(Fit 41-42)	5.95	0	Black,40-41(Fit 39-40)	5.94	971	Cream,42-43(Fit 41-42)	5.95	0	Grey,44-45(Fit 43-44)	5.94	967	Navy,38-39(Fit 37-38)	5.95	0	Yellow,44-45(Fit 43-44)	5.95	0	Grey,40-41(Fit 39-40)	5.94	969	Navy,42-43(Fit 41-42)	5.94	962	Yellow,38-39(Fit 37-38)	5.94	987	Black,38-39(Fit 37-38)	5.94	969	Pink,44-45(Fit 43-44)	5.95	0	Green,38-39(Fit 37-38)	5.94	975	Black,42-43(Fit 41-42)	5.94	958	Navy,40-41(Fit 39-40)	5.94	960	Green,36-37(Fit 35-36)	5.94	981	Grey,36-37(Fit 35-36)	5.95	0	Green,40-41(Fit 39-40)	5.94	977	Navy,36-37(Fit 35-36)	5.95	0	Pink,38-39(Fit 37-38)	5.94	940	Cream,40-41(Fit 39-40)	5.94	973	Shoe brush,38-39(Fit 37-38)	5.95	0	Green,42-43(Fit 41-42)	5.94	978	Grey,38-39(Fit 37-38)	5.95	0	Pink,36-37(Fit 35-36)	5.94	965	Cream,38-39(Fit 37-38)	5.94	966	Black,36-37(Fit 35-36)	5.94	987	Yellow,40-41(Fit 39-40)	5.94	987	Pink,42-43(Fit 41-42)	5.95	0	Black,44-45(Fit 43-44)	5.94	955	Green,44-45(Fit 43-44)	5.94	983	Yellow,36-37(Fit 35-36)	5.94	993	Shoe brush,44-45(Fit 43-44)	5.95	0
3	31/05/2022 21:01:15	Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman	ABC	0.85	5.94	25238	5104	546	Navy,38-39(Fit 37-38)	5.95	0	Grey,40-41(Fit 39-40)	5.94	970	Shoe brush,42-43(Fit 41-42)	5.95	0	Pink,40-41(Fit 39-40)	5.94	962	Grey,42-43(Fit 41-42)	5.94	949	Grey,38-39(Fit 37-38)	5.95	0	Yellow,36-37(Fit 35-36)	5.94	993	Black,42-43(Fit 41-42)	5.94	958	Navy,44-45(Fit 43-44)	5.94	961	Pink,42-43(Fit 41-42)	5.95	0	Shoe brush,44-45(Fit 43-44)	5.95	0	Grey,44-45(Fit 43-44)	5.94	967	Yellow,38-39(Fit 37-38)	5.94	987	Green,44-45(Fit 43-44)	5.94	983	Green,42-43(Fit 41-42)	5.94	978	Pink,44-45(Fit 43-44)	5.95	0	Cream,38-39(Fit 37-38)	5.94	967	Navy,36-37(Fit 35-36)	5.95	0	Black,44-45(Fit 43-44)	5.94	955	Navy,40-41(Fit 39-40)	5.94	960	Navy,42-43(Fit 41-42)	5.94	962	Shoe brush,38-39(Fit 37-38)	5.95	0	Shoe brush,40-41(Fit 39-40)	5.95	0	Cream,42-43(Fit 41-42)	5.95	0	Cream,44-45(Fit 43-44)	5.95	0	Green,36-37(Fit 35-36)	5.94	981	Grey,36-37(Fit 35-36)	5.95	0	Green,40-41(Fit 39-40)	5.94	977	Black,36-37(Fit 35-36)	5.94	987	Yellow,40-41(Fit 39-40)	5.94	987	Cream,36-37(Fit 35-36)	5.94	972	Yellow,42-43(Fit 41-42)	5.95	0	Yellow,44-45(Fit 43-44)	5.95	0	Black,40-41(Fit 39-40)	5.94	971	Green,38-39(Fit 37-38)	5.94	975	Black,38-39(Fit 37-38)	5.94	969	Shoe brush,36-37(Fit 35-36)	0.85	989	Pink,36-37(Fit 35-36)	5.94	965	Pink,38-39(Fit 37-38)	5.94	940	Cream,40-41(Fit 39-40)	5.94	973
4	31/05/2022 19:15:05	Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman	ABC	0.85	5.94	25243	5102	546	Green,44-45(Fit 43-44)	5.94	983	Cream,42-43(Fit 41-42)	5.95	0	Cream,40-41(Fit 39-40)	5.94	974	Black,38-39(Fit 37-38)	5.94	969	Pink,44-45(Fit 43-44)	5.95	0	Pink,42-43(Fit 41-42)	5.95	0	Shoe brush,40-41(Fit 39-40)	5.95	0	Shoe brush,36-37(Fit 35-36)	0.85	989	Black,36-37(Fit 35-36)	5.94	987	Grey,38-39(Fit 37-38)	5.95	0	Green,42-43(Fit 41-42)	5.94	978	Pink,36-37(Fit 35-36)	5.94	965	Cream,38-39(Fit 37-38)	5.94	968	Yellow,36-37(Fit 35-36)	5.94	993	Cream,44-45(Fit 43-44)	5.95	0	Navy,42-43(Fit 41-42)	5.94	963	Shoe brush,44-45(Fit 43-44)	5.95	0	Yellow,38-39(Fit 37-38)	5.94	987	Shoe brush,42-43(Fit 41-42)	5.95	0	Yellow,40-41(Fit 39-40)	5.94	987	Grey,42-43(Fit 41-42)	5.94	949	Yellow,44-45(Fit 43-44)	5.95	0	Navy,38-39(Fit 37-38)	5.95	0	Green,40-41(Fit 39-40)	5.94	977	Green,38-39(Fit 37-38)	5.94	975	Shoe brush,38-39(Fit 37-38)	5.95	0	Navy,36-37(Fit 35-36)	5.95	0	Black,40-41(Fit 39-40)	5.94	971	Navy,44-45(Fit 43-44)	5.94	961	Grey,40-41(Fit 39-40)	5.94	971	Cream,36-37(Fit 35-36)	5.94	972	Grey,36-37(Fit 35-36)	5.95	0	Yellow,42-43(Fit 41-42)	5.95	0	Pink,38-39(Fit 37-38)	5.94	941	Green,36-37(Fit 35-36)	5.94	981	Navy,40-41(Fit 39-40)	5.94	960	Black,44-45(Fit 43-44)	5.94	955	Black,42-43(Fit 41-42)	5.94	958	Pink,40-41(Fit 39-40)	5.94	962	Grey,44-45(Fit 43-44)	5.94	967
5	31/05/2022 15:22:05	Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman	ABC	0.85	5.94	25244	5099	546	Pink,44-45(Fit 43-44)	5.95	0	Black,38-39(Fit 37-38)	5.94	970	Green,44-45(Fit 43-44)	5.94	983	Shoe brush,38-39(Fit 37-38)	5.95	0	Shoe brush,44-45(Fit 43-44)	5.95	0	Yellow,44-45(Fit 43-44)	5.95	0	Yellow,38-39(Fit 37-38)	5.94	987	Cream,38-39(Fit 37-38)	5.94	968	Black,40-41(Fit 39-40)	5.94	971	Navy,36-37(Fit 35-36)	5.95	0	Green,40-41(Fit 39-40)	5.94	977	Navy,40-41(Fit 39-40)	5.94	960	Navy,38-39(Fit 37-38)	5.95	0	Grey,44-45(Fit 43-44)	5.94	967	Cream,36-37(Fit 35-36)	5.94	972	Pink,38-39(Fit 37-38)	5.94	941	Pink,42-43(Fit 41-42)	5.95	0	Green,42-43(Fit 41-42)	5.94	978	Shoe brush,36-37(Fit 35-36)	0.85	989	Grey,40-41(Fit 39-40)	5.94	971	Cream,44-45(Fit 43-44)	5.95	0	Pink,40-41(Fit 39-40)	5.94	962	Grey,38-39(Fit 37-38)	5.95	0	Cream,42-43(Fit 41-42)	5.95	0	Yellow,42-43(Fit 41-42)	5.95	0	Black,36-37(Fit 35-36)	5.94	987	Navy,42-43(Fit 41-42)	5.94	963	Green,36-37(Fit 35-36)	5.94	981	Black,42-43(Fit 41-42)	5.94	958	Pink,36-37(Fit 35-36)	5.94	965	Yellow,36-37(Fit 35-36)	5.94	993	Black,44-45(Fit 43-44)	5.94	955	Cream,40-41(Fit 39-40)	5.94	974	Shoe brush,42-43(Fit 41-42)	5.95	0	Grey,36-37(Fit 35-36)	5.95	0	Shoe brush,40-41(Fit 39-40)	5.95	0	Green,38-39(Fit 37-38)	5.94	975	Navy,44-45(Fit 43-44)	5.94	961	Grey,42-43(Fit 41-42)	5.94	949	Yellow,40-41(Fit 39-40)	5.94	987
6	31/05/2022 15:15:05	Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman	ABC	0.85	5.94	25244	5099	546	Pink,44-45(Fit 43-44)	5.95	0	Black,38-39(Fit 37-38)	5.94	970	Green,44-45(Fit 43-44)	5.94	983	Shoe brush,38-39(Fit 37-38)	5.95	0	Shoe brush,44-45(Fit 43-44)	5.95	0	Yellow,44-45(Fit 43-44)	5.95	0	Yellow,38-39(Fit 37-38)	5.94	987	Cream,38-39(Fit 37-38)	5.94	968	Black,40-41(Fit 39-40)	5.94	971	Navy,36-37(Fit 35-36)	5.95	0	Green,40-41(Fit 39-40)	5.94	977	Navy,40-41(Fit 39-40)	5.94	960	Navy,38-39(Fit 37-38)	5.95	0	Grey,44-45(Fit 43-44)	5.94	967	Cream,36-37(Fit 35-36)	5.94	972	Pink,38-39(Fit 37-38)	5.94	941	Pink,42-43(Fit 41-42)	5.95	0	Green,42-43(Fit 41-42)	5.94	978	Shoe brush,36-37(Fit 35-36)	0.85	989	Grey,40-41(Fit 39-40)	5.94	971	Cream,44-45(Fit 43-44)	5.95	0	Pink,40-41(Fit 39-40)	5.94	962	Grey,38-39(Fit 37-38)	5.95	0	Cream,42-43(Fit 41-42)	5.95	0	Yellow,42-43(Fit 41-42)	5.95	0	Black,36-37(Fit 35-36)	5.94	987	Navy,42-43(Fit 41-42)	5.94	963	Green,36-37(Fit 35-36)	5.94	981	Black,42-43(Fit 41-42)	5.94	958	Pink,36-37(Fit 35-36)	5.94	965	Yellow,36-37(Fit 35-36)	5.94	993	Black,44-45(Fit 43-44)	5.94	955	Cream,40-41(Fit 39-40)	5.94	974	Shoe brush,42-43(Fit 41-42)	5.95	0	Grey,36-37(Fit 35-36)	5.95	0	Shoe brush,40-41(Fit 39-40)	5.95	0	Green,38-39(Fit 37-38)	5.94	975	Navy,44-45(Fit 43-44)	5.94	961	Grey,42-43(Fit 41-42)	5.94	949	Yellow,40-41(Fit 39-40)	5.94	987
7	31/05/2022 11:15:06	Slippers Slipper Home Slipper Slippers Men Bathroom Slippers Indoor Slipper Home Slippers Indoor Slippers Indoor Slippers Woman	ABC	0.85	5.94	25247	5094	546	Black,44-45(Fit 43-44)	5.94	955	Black,42-43(Fit 41-42)	5.94	958	Navy,36-37(Fit 35-36)	5.95	0	Cream,40-41(Fit 39-40)	5.94	974	Green,44-45(Fit 43-44)	5.94	983	Yellow,40-41(Fit 39-40)	5.94	987	Cream,38-39(Fit 37-38)	5.94	968	Shoe brush,44-45(Fit 43-44)	5.95	0	Navy,38-39(Fit 37-38)	5.95	0	Navy,42-43(Fit 41-42)	5.94	963	Black,36-37(Fit 35-36)	5.94	987	Shoe brush,36-37(Fit 35-36)	0.85	989	Cream,36-37(Fit 35-36)	5.94	972	Grey,44-45(Fit 43-44)	5.94	967	Green,36-37(Fit 35-36)	5.94	981	Black,40-41(Fit 39-40)	5.94	972	Green,40-41(Fit 39-40)	5.94	978	Shoe brush,38-39(Fit 37-38)	5.95	0	Yellow,44-45(Fit 43-44)	5.95	0	Pink,38-39(Fit 37-38)	5.94	941	Yellow,36-37(Fit 35-36)	5.94	993	Grey,42-43(Fit 41-42)	5.94	949	Grey,40-41(Fit 39-40)	5.94	971	Shoe brush,40-41(Fit 39-40)	5.95	0	Shoe brush,42-43(Fit 41-42)	5.95	0	Yellow,38-39(Fit 37-38)	5.94	987	Pink,42-43(Fit 41-42)	5.95	0	Grey,38-39(Fit 37-38)	5.95	0	Black,38-39(Fit 37-38)	5.94	970	Pink,44-45(Fit 43-44)	5.95	0	Cream,42-43(Fit 41-42)	5.95	0	Cream,44-45(Fit 43-44)	5.95	0	Pink,40-41(Fit 39-40)	5.94	962	Green,42-43(Fit 41-42)	5.94	978	Pink,36-37(Fit 35-36)	5.94	965	Yellow,42-43(Fit 41-42)	5.95	0	Navy,40-41(Fit 39-40)	5.94	961	Green,38-39(Fit 37-38)	5.94	975	Grey,36-37(Fit 35-36)	5.95	0	Navy,44-45(Fit 43-44)	5.94	961
Sheet1

 

[Goodluckboss]

Insert an image for better context