Quick way to delete every second column

[mss90]

Is there a quick way to delete every second column in a Excel spreadsheet?

[Roydemooij]

Try this

Please Login or Register  to view this content.

[sandy666]

with Power Query

Column1

Column2

Column3

Column4

Column5

Column6

Column7

Column8

Column9

Column10

Column11

Column12

Column13

Column14

Column1

Column3

Column5

Column7

Column9

Column11

Column13

Please Login or Register  to view this content.

[menem]

If all column you want to delete have the same value but different from 1st column.
you may use goto special to select all difference value and delete columns.

Regards.

[menem]

the output will be.

[mss90]

Thanks, everyone for getting back to be about this. Im sure all the suggested solutions work but in this case Im just going with the "go to special".

Works like a breeze and easy to do