Forum Discussion

asadmustafa's avatar
asadmustafa
Regular Visitor
3 years ago

Creating a duplicate column and filtering

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...
Need Help
asadmustafa's avatar
asadmustafa
Regular Visitor
3 years ago

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