3

I have two Excel sheets and one sheet has more columns than the other sheet and I need to identify those columns that are not present in both sheets.

I've tried using Beyond Compare tool but cannot figure out how to identify columns not present in both sheets.

Pliskin
  • 125
  • 2
  • 9

1 Answers1

3

Remark in advance: I use beyond compare 4 Pro Edition. I'm not sure if each function is available in the non-pro version.

If I compare

enter image description here

and

enter image description here

Then I get: enter image description here

You can see the red little square on the first different column.

You could add now a dummy columns at this place (Excel) Then you get: enter image description here

The columns with different columns are again marked red.

In Session->Session Settings you can check the column mapping: enter image description here

With the right mouse click you can move the columns: enter image description here

The result: enter image description here

Another possibility (without data comparison):

I need to identify those columns that are not present in both sheets.

  1. Open a new text compare in beyond compare.
  2. Go to your first excel and mark the header line, Copy the line (Ctrl-C)
  3. Paste the line in Beyond compare
  4. Go to your second excel and mark the header line, Copy the line (Ctrl-C)
  5. Paste the line in Beyond compare
  6. check the result:\enter image description here
knut
  • 27,320
  • 6
  • 84
  • 112
  • Thank you, Knut, your second recommendation was the easiest and most obvious! Worked perfectly. – Pliskin Sep 17 '19 at 14:31