sort single row/multiple columns

Is there a way to sort a portion of a single row over multiple columns, without having to specify a Sort by column?

I have individual words...

Find Replace and Update

let
    Table2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

Find Replace and Update

Hello Everyone,

New user here, I am trying to do the following between two tables that have several thousand lines.

I have...

workload allocation w/ skills matrix

Cross-posted (and answered) at: https://chandoo.org/forum/threads/wo...-matrix.43173/
Also cross-posted at:
https://www.excelforum.com/excel-pro...ls-matrix.html...

Remove duplicate cell value and not the actual cell.

If you just don't want to see the value, you could use conditional formatting over A1:A11 with a formula of =COUNTIF($A$1:$A1,$A2) and set the font colour...