Sorting Multiple Columns with duplicates

[Erika7]

I need to create a sorting method and/or macro to sort the entire table but with 4 of the columns (D-G below) being similarly sorted/grouped where values may be found in any (or all) of the 4. Please see the example below to get a better understanding of the situation. There are actually 31 columns, but I'm only showing 8 for example purposes. It should first sort by Date, then Location (Front, Right, Back, Left) based on Unique ID then the other hidden columns.

The part I'm getting stuck is sorting the Locations: I need it to be able to sort similar 'Unique IDs' based on the numbers found in the locations; however, the numbers can be found in any of the 4 locations and on any of the unique # rows.

A1 Unique ID	B Date	C Type	D Front	E Right	F Left	G Back	H Time
2 1001	1/1	A	23	0	0	0	0.10
3 1002	1/1	A	21	0	70	0	0.20
4 1003	1/1	B	21	0	0	0	0.10
5 1004	1/1	C	0	23	0	0	0.10
6 1005	1/1	A	70	0	0	0	0.10
7 1006	1/2	B	0	0	0	29	0.10
8 1007	1/2	A	17	0	0	0	0.10

<tbody>
</tbody>

See below for ideal answer. Note that the rows are sorted first by Date, then the Location IDs are sorted adjacently (it should know which line to sort next based on the Unique ID order - smallest ID always goes first)

A1 Unique ID	B Date	C Type	D Front	E Right	F Left	G Back	H Time
2 1001	1/1	A	23	0	0	0	0.10
3 1004	1/1	C	0	23	0	0	0.10
4 1005	1/1	A	70	0	0	0	0.10
5 1002	1/1	A	21	0	70	0	0.20
6 1003	1/1	B	21	0	0	0	0.10
7 1006	1/2	B	0	0	0	29	0.10
8 1007	1/2	A	17	0	0	0	0.10

<tbody>
</tbody>

I understand this may be confusing, but any help is greatly appreciated! Thanks in advance!!!

 

[jsa1987]

It is a little confusing. What is the logic that 1005 (with Front = 70) comes before 1002 (with Front = 21 & Left = 70)?

 

[Erika7]

Sorry, you're correct. The final answer should have ID 1003 and 1005 flipped. Thank you for catching that.

It is a little confusing. What is the logic that 1005 (with Front = 70) comes before 1002 (with Front = 21 & Left = 70)?