Can someone help me figure out the code for grouping 2 columns together before sorting by columns?
example data:
where columns A & B need to be grouped together, C & D together, E & F together, etc...
When the sort is done it is only to sort by the name column (first column in each group of 2... A = Steve, C = John, E = Zeke... etc)
so before sort:
<tbody>
</tbody>
and after sorting and with grouping every 2 columns together:
<tbody>
</tbody>
example data:
where columns A & B need to be grouped together, C & D together, E & F together, etc...
When the sort is done it is only to sort by the name column (first column in each group of 2... A = Steve, C = John, E = Zeke... etc)
so before sort:
A | B | C | D | E | F | G | H | |
1 | Steve | 6/9/2010 | John | 1/1/2017 | Zeke | 5/5/2013 | Adam | 2/5/2008 |
2 | 12/17/2014 | 8/5/2013 | 1/18/2012 | 8/4/2015 | ||||
3 | 9/1/2010 | 10/2/2016 | 11/19/2014 | 5/27/2011 |
<tbody>
</tbody>
and after sorting and with grouping every 2 columns together:
A | B | C | D | E | F | G | H | |
1 | Adam | 2/5/2008 | John | 1/1/2017 | Steve | 6/9/2010 | Zeke | 5/5/2013 |
2 | 8/4/2015 | 8/5/2013 | 12/17/2014 | 1/18/2012 | ||||
3 | 5/27/2011 | 10/2/2016 | 9/1/2010 | 11/19/2014 |
<tbody>
</tbody>