Removing duplicates

[tiredofit]

I am trying to remove duplicates using Power Query and have encountered a step which I don't know what it means.

I am using Excel 2019.

Step 1. Go to Data -> Get Data -> From File -> From Workbook

Step 2. Select workbook, click OK

Step 3. Select worksheet within the workbook, then select Transform

My data contains a mixture of numbers and text. At present the data type 123, (ie Whole number) so I click on the 123 and choose text.

I am presented with a message:

Change Column Type

The selected column has an existing type conversion. Would you like to replace the existing conversion, or preserve the existing conversion and add the new conversion as a separate step?

There are three buttons: Replace current, Add new step and cancel.

What does the message mean?

When I chose Add new step then remove dupicates and close and load, I got an error message:

[DataFormat.Error] We couldn't  convert to Number

What is wrong?

Thanks

 

[tiredofit]

so we are different, I am against vba in any form
for PQ you need IDEA first

I have limited knowledge of PQ and PowerPivot but I think I am correct in saying VBA can do everything they can do plus more.

Only problem is it takes time to write VBA code, instead of clicking and dragging to get results in seconds.

 

[sandy666]

as I said: we are different
which sport is better: football or hockey
which system is better: Unix or Windows

I think I am correct in saying VBA can do everything they can do plus more.

this is just your opinion

 

[tiredofit]

as I said: we are different
which sport is better: football or hockey
which system is better: Unix or Windows

we're not different, I agree with you, we're different

 

[sandy666]

we're not different, I agree with you, we're different