Sort Rows - Keep Distinct Values

[Mcook13]

Calling all Query experts,

I'm sure this is a simple fix, but I am looking to sort a row by their Line # in the 2nd column, but maintain the original order in the 1st column.

Example below. Input is how my data on the table comes in and Output is what I am trying to achieve. Any help is appreciated.

Input
Col 1 - Col 2
def - 3
def - 1
def - 2
abc - 2
abc - 1
ghi - 1

Output
Col 1 - Col 2
def - 1
def - 2
def - 3
abc - 1
abc - 2
ghi - 1

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
    GroupRows = Table.Group(Source, {"Column1"}, {{"Column2", each _, type table [Column1=text, Column2=number]}}),
    ttc = Table.TransformColumns(GroupRows, {"Column2", (x) => List.Sort(x[Column2])}),
    Expand = Table.ExpandListColumn(ttc, "Column2")
in
    Expand

Book2
	A	B	C	D	E	F
1	Column1	Column2		Column1	Column2
2	def	3		def	1
3	def	1		def	2
4	def	2		def	3
5	abc	2		abc	1
6	abc	1		abc	2
7	ghi	1		ghi	1
8
Sheet3

 

[Mcook13]

let
    Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
    GroupRows = Table.Group(Source, {"Column1"}, {{"Column2", each _, type table [Column1=text, Column2=number]}}),
    ttc = Table.TransformColumns(GroupRows, {"Column2", (x) => List.Sort(x[Column2])}),
    Expand = Table.ExpandListColumn(ttc, "Column2")
in
    Expand

Book2
	A	B	C	D	E	F
1	Column1	Column2		Column1	Column2
2	def	3		def	1
3	def	1		def	2
4	def	2		def	3
5	abc	2		abc	1
6	abc	1		abc	2
7	ghi	1		ghi	1
8
Sheet3

Hi JGorden11,

It almost worked. I had not included the fact that there are columns after column 2. Those columns have distinct values.
If it helps to understand, Col 1 = PO number, Col 2 = Line #, Col 3 = Ship to address, Col 4 = Qty ordered

Input
Col 1 - Col 2 - Col 3 - Col 4
def - 3 - xyz - 200
def - 1 - xyz - 50
def - 2 - xyz - 10
abc - 2 - qrs - 35
abc - 1 - qrs - 40
ghi - 1 - lmn - 12

Output
Col 1 - Col 2 - Col 3 - Col 4
def - 1- xyz - 50
def - 2- xyz - 10
def - 3- xyz - 200
abc - 1- qrs - 40
abc - 2- qrs - 35
ghi - 1 - lmn - 12

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
    tcn = Table.ColumnNames(Source),
    tcn2 = List.Skip(tcn,1),
    GroupRows = Table.Group(Source, {tcn{0}}, {{"Grouped", each _}}),
    AddIndex = Table.AddIndexColumn(GroupRows, "Index", 0, 1, Int64.Type),
    ExpandCount = Table.ExpandTableColumn(AddIndex, "Grouped", tcn2, tcn2),
    Result = Table.SelectColumns(Table.Sort(ExpandCount,{{"Index", Order.Ascending}, {tcn{1}, Order.Ascending}}),tcn)
in
    Result

delme1R1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Column1	Column2	Column3	Column4		Column1	Column2	Column3	Column4
2	def	3	xyz	200		def	1	xyz	50
3	def	1	xyz	50		def	2	xyz	10
4	def	2	xyz	10		def	3	xyz	200
5	abc	2	qrs	35		abc	1	qrs	40
6	abc	1	qrs	40		abc	2	qrs	35
7	ghi	1	lmn	12		ghi	1	lmn	12
8
Sheet8

 

[Mcook13]

let
    Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
    tcn = Table.ColumnNames(Source),
    tcn2 = List.Skip(tcn,1),
    GroupRows = Table.Group(Source, {tcn{0}}, {{"Grouped", each _}}),
    AddIndex = Table.AddIndexColumn(GroupRows, "Index", 0, 1, Int64.Type),
    ExpandCount = Table.ExpandTableColumn(AddIndex, "Grouped", tcn2, tcn2),
    Result = Table.SelectColumns(Table.Sort(ExpandCount,{{"Index", Order.Ascending}, {tcn{1}, Order.Ascending}}),tcn)
in
    Result

delme1R1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Column1	Column2	Column3	Column4		Column1	Column2	Column3	Column4
2	def	3	xyz	200		def	1	xyz	50
3	def	1	xyz	50		def	2	xyz	10
4	def	2	xyz	10		def	3	xyz	200
5	abc	2	qrs	35		abc	1	qrs	40
6	abc	1	qrs	40		abc	2	qrs	35
7	ghi	1	lmn	12		ghi	1	lmn	12
8
Sheet8

Groovy baby! It worked! Thank you very much for your help