0

I will explain my problem with following pictures:

1

2

As you can see there is the column 'BvD ID number' that has the same variables (in picture 2 they occur more often). I would like to merge these two so that I can have picture one with the added information of picture 2.

How can I do this?

Thanks in advance

Burgi
  • 6,768
Jules
  • 1

1 Answers1

0

Without Pivot table, you can use Subtotal to get what you want (but not in your desired format, but close enough).

  1. Make sure your ID is sorted.

Sample data

  1. Select your whole table, including the header.

  2. Go to Data tab, and click on Subtotal

Data tab, then Subtotal

  1. Select ID on At each change in, use function Count, and check ID on Add subtotal to

Creating subtotal

  1. You can click on - icon to collapse the detailed info to form a count summary only.

Result Summary

Vylix
  • 1,935