Hello,
I have 3 columns (levels) and each column has a Order column,i want to sort teh column but the problem is my columns have duplicates values like that:
| Group | Level 1 | level 2 | level 3 | Order 1 | Order 2 | Order 3 |
| Store | A | 1a | Ax | 1 | 1 | 2 |
| Store | B | 1b | Bx | 3 | 2 | 1 |
| Store | B | 2b | By | 3 | 3 | 3 |
| Store | C | 1c | Cx | 2 | 4 | 4 |
| Store | C | 1C | Cy | 2 | 4 | 5 |
| Head | A | 1a | Ax | 1 | 1 | 1 |
| Head | B | 1b | Bz | 2 | 2 | 2 |
| Head | B | 2b | Bw | 3 | 3 | 3 |
I create duplicates columns, concatenate group and level to remove duplicates values in each column and sort by Orders columns. But with this solution I have to display Group/Level 1 ( Head/A, Head/B, Store/A,Store B,....), Group/Level 2,... and I want to display only the level without .
Do you have any other ideas?
Thank you for your help
