Forum Discussion

Jon_E1972's avatar
Jon_E1972
Copper Contributor
Feb 25, 2020
Solved

multiple same set columns

I have two columns, they are postcode prefixes (UK), so I have 147 postcodes, but I want to go from each postcode to the other. so, for example, W1 postcode to all other 147 postcodes, including W1.

 

So I will have W1 to W1, W2, W3 etc, etc to W147 (using W1 to W147 is made up but it is easier to describe this way)

 

Then I want to go from W2 to all postcodes, but I have already got the row from W1 to W2 so I don't need to have a row with W2 to W1

 

I already have a sheet with all the variations on it i.e. W1 to all postcodes, W2 to all postcodes, W3 to all postcodes, there are 21k's worth of values. 

So how do i remove the rows where the i have duplicates?

 

below is the actual values 

 

FromTo
BR1BR1
BR1BR2
BR1BR3
BR1BR4
BR1BR5

 

as you can see i have BR1 to BR2, so I don't need BR2 to BR1

 

BR2BR1
BR2BR2
BR2BR3
BR2BR4
BR2BR5

 

how do I find and remove these duplicates?

 

I've hunted about and don't seem to be able to find anything. I've attached the file. 

 

Thanks

Jon 

  • Jon_E1972 I made some columns to find the duplicate rows in the attached (anything with a 2).  I've left them in to show how it works but you can filter to find the duplicates and then remove both them and the helper columns I added.

2 Replies

  • Savia's avatar
    Savia
    Iron Contributor

    Jon_E1972 I made some columns to find the duplicate rows in the attached (anything with a 2).  I've left them in to show how it works but you can filter to find the duplicates and then remove both them and the helper columns I added.

    • Jon_E1972's avatar
      Jon_E1972
      Copper Contributor

      Savia thanks for that, every row with a 2 is a repeat. Perfect, thanks Savia. 

Resources