Hi Everyone

I'm new to the forums and I have been searching around to try and find a solution to my problem but have not been able to find anything similar as yet.

For starters, I'm working on Excel 2013.

I have a sheet containing data for bookings made for various sites. Column A lists the site number, column B lists the customer who has booked the site and columns C & D show the booking start and end dates. In the remaining columns to the right I'm basically using a formula to populate the customer name if the site is booked for the particular month which the column has been labeled.

Here's is a screenshot of the current sheet:
Current sheet.jpg

Now, as you can see, it is possible to have the same site number listed multiple times in column A. The booking period will however be different.

What I am trying to achieve is a single consolidated view showing me all the site numbers sorted in ascending order as single line items with just the customer names updated in the month columns to the right based on the booking periods.

Here a sample screenshot of the desired end result:
Required sheet.jpg

Any help would be appreciated!

Many thanks!
Marnus