Creating a duplicate column and filtering

[asadmustafa]

Hi there,

I am trying to create a duplicate column. My original column  is 'Status' and I am duplicating this and renaming it as 'Rejected'. When I am filtering the 'Rejected' column, it is doing the same for my original 'Status' column as well and putting the same filter on that column. I have tried everything, did try to create an empty column and Fill-Up as well but nothing work.

Please help me in this regard.

Thanks

[asadmustafa]

@HotChilli so I am taking my data from sharepoint online list. I have a column in my data named 'Status'. There are following 6 fields in Status column:
Rejected, Implemented, No longer applicable, Further Information Required, Not Implemented, Response Submitted. 

What I want is to separte the first three fields in three separate columns and the last three fields in one column.

For that purpose, I am duplicating my Status column and renaming it 'Rejected'. Then I am filtering the 'Rejected' field from the dropdown but when I do this, it filtered my original 'Status' column as well.

I am doing this in Power Query Editor. 

I am looking for a way in which when I filter the duplicated column, it doesn't effect my original Status column.

Thanks

[isha_dhameliya]

for that, first you have to

1. make duplicate table then

2. filter the column from the duplicate table 

3. then go to the original table and select the merge query option

4. select the duplicate table as second table and select the common column from both the table

5. select left outer join then one extra column will be create.

6. from that table you can expand the joined column

[HotChilli]

It's not clear what your desired result is.

Please show us what you have and what you want afterwards as a result (with an explanation)