I did not see a previous Q and A on this, but I am sorry if it has been asked & answered in the past.
My problem: I need to sort data across three columns, but preserve the alpha order across the three columns.
For example:
[TABLE="width: 15"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Baker[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Billy[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Charles[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Chuck[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Conner[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]David[/TD]
[/TR]
</tbody>[/TABLE]
This order is easy: alpha...the issue is maintaining the data in the original column.
What am I missing?
Thanks!
My problem: I need to sort data across three columns, but preserve the alpha order across the three columns.
For example:
[TABLE="width: 15"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Baker[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Billy[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Charles[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Chuck[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Conner[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]David[/TD]
[/TR]
</tbody>[/TABLE]
This order is easy: alpha...the issue is maintaining the data in the original column.
What am I missing?
Thanks!