Knockoutpie
Board Regular
- Joined
- Sep 10, 2018
- Messages
- 116
- Office Version
- 365
- Platform
- Windows
Hi everyone,
Is there a way to rearrange the columns based on values in the cell and not based on the headers?
for example the first rearrange would be Username, Hint, Password, Site, the second rearrange would be Password, Username, Site, Hint.
If i'm not being clear enough, please let me know and i'll try and be more descriptive.
[TABLE="width: 288"]
<tbody>[TR]
[TD="class: xl63, width: 72, align: right"]1[/TD]
[TD="class: xl63, width: 72, align: right"]3[/TD]
[TD="class: xl63, width: 72, align: right"]2[/TD]
[TD="class: xl63, width: 72, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl64"]Username[/TD]
[TD="class: xl64"]Password[/TD]
[TD="class: xl64"]Hint[/TD]
[TD="class: xl64"]Site[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to rearrange the columns based on values in the cell and not based on the headers?
for example the first rearrange would be Username, Hint, Password, Site, the second rearrange would be Password, Username, Site, Hint.
If i'm not being clear enough, please let me know and i'll try and be more descriptive.
[TABLE="width: 288"]
<tbody>[TR]
[TD="class: xl63, width: 72, align: right"]1[/TD]
[TD="class: xl63, width: 72, align: right"]3[/TD]
[TD="class: xl63, width: 72, align: right"]2[/TD]
[TD="class: xl63, width: 72, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]4[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl64"]Username[/TD]
[TD="class: xl64"]Password[/TD]
[TD="class: xl64"]Hint[/TD]
[TD="class: xl64"]Site[/TD]
[/TR]
</tbody>[/TABLE]