I have a set of data that I imported from a PDF file into Excel.

The issue is that some of the columns have been split into 2 rows, while some others are fine.

I’ve added an image which shows what the issue is and the outcome that I would like. The data has a little over 1000 rows, so I’m hoping some sort of VBA code could help with this. (note that some rows are fine and do not need to be modified such as Contract 3).

The issue and outcome

I was thinking of a VBA code that would check if the row below in Column A is blank/null. If true, then it would concatenate the rows in Columns B and C. Not sure how I would code this though, as I don’t know VBA that well. Any other suggestions would be greatly appreciated!