How to combine two columns as one column with unique value

Hi,

We are a bit unclear about your question about Unique values,

However, as per our understanding,

You can append Query in Power Query Editor, Please follow the steps below,

1. Duplicate the Required Table,
2. Remove the first column and rename the second column in the original table,
3. Remove the Second column and rename the first column in the Duplicate table,
4. Navigate to the Append Queries,
5. Choose the table to Append

In the below sample table, we are looking to combine Both date fields in one as Date,

Please refer the below screenshots,

After Updating the tables,

Navigate to the Append as new, (Top - Right)

After Append the Tables,

Let us know if this is an expected result for you or if not then could you explain more about your query with sample data?

Hello,

I have so many columns on original table, I tried to merger both the tables, datas are duplicatiing. because it is whenever First column has value thne second column is empty and vice versa.

Is there way we can achieve thru query?

Avian

Hi avi081265 ,

please provide a sample data that we can copy and show your expected output