muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,089
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to make series alphabetically based on unique adjacent cell...
[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]order/desired[/TH]
[TH]data[/TH]
[/TR]
</thead><tbody> [TR]
[TD]A[/TD]
[TD]apple[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]banana[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]banana[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]etc..[/TD]
[TD]avocado[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]blackberry[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]blackberry[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]blackberry[/TD]
[/TR]
</tbody>[/TABLE]
my target in column order/desired
any help greatly appreciated..
m.susanto
how to make series alphabetically based on unique adjacent cell...
[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]order/desired[/TH]
[TH]data[/TH]
[/TR]
</thead><tbody> [TR]
[TD]A[/TD]
[TD]apple[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]banana[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]banana[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]apricot[/TD]
[/TR]
[TR]
[TD]etc..[/TD]
[TD]avocado[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]blackberry[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]blackberry[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]blackberry[/TD]
[/TR]
</tbody>[/TABLE]
my target in column order/desired
any help greatly appreciated..
m.susanto
Last edited: