Excel VBA for Row Combination

I need an Excel VBA or function that can combine multiple rows on a worksheet. There will be two variables (Column B and C) that need to be the same for the rows to combine. The data in the other columns should be concatenated into a single cell, delimited by a semicolon.

Ideal skills for this project include:
- Proficiency in Excel and VBA
- Strong understanding of data manipulation
- Ability to create efficient functions for data processing.