Sort rows according to master column

[jsarp]

Hi All,

I'm trying to sort a spreadsheet so that all columns following the first will follow the same indexing as the first column, as shown below

Thanks!

 

[MARK858]

Welcome to the forum, maybe....

Book1
	A	B	C	D	E	F	G	H	I	J
1		Op 1	Op 2	Op 3				Op 1	Op 2	Op 3
2	Name	Name	Name	Name			Name	Name	Name	Name
3	a	2	b	c			a			a
4	b	c	3	b			b		b	b
5	c		1	a			c	c		c
6	1			3			1		1	1
7	2			1			2	2
8	3						3		3	3
Sheet3

Cell Formulas
Range	Formula
H3:J8	H3	=IF(COUNTIF(B$3:B$8,$G3)=0,"",$G3)

 

[jsarp]

Honestly that was great! Thank you so much for such a great and quick response.

 

[MARK858]

Happy it helped