title: Turn multiple columns into one column value DAX/PowerBI
body: <p>I am trying to turn multiple columns into one column value DAX/PowerBI.</p>
  
  <p>I have a <code>table1</code> with some columns name <code>Phone No.1</code>, <code>Phone No.2</code>, <code>Phone No.3</code>, <code>Phone No.4</code>, <code>Phone No.5</code>, <code>Phone No.6</code> and also <code>table 2</code> with the columns name <code>Phone No.1</code>, <code>Phone No.2</code>, <code>Phone No.3</code>, <code>Phone No.4</code>, <code>Phone No.5</code>, <code>Phone No.6</code>.</p>
  
  <p>Now I would like to have a table with a column of unique values from all those columns.</p>
  
  <p>I have search a lot to find a solution, but unfortunately, It seems like there is no solution to this challenge!</p>
  
  <p>Do anyone knows any way or any solution to solve this challenge!</p>