Not sure if anyone can advise on this one.
I have a simple but rather large spreadsheet of data with a repeat pattern of three columns across the page. Column A is source, Column B is description and Column C is measure. This pattern repeats across the page.
Not all the data in B is repeated so when each batch is dropped onto the excell page they don't always line up.

The Column B data can appear in any of the subsequent E, H,K columns but must be kept with there related A,C D,F G,I partners.
Can anyone come up with a formula that will select and align the matches in B, E, K etc while retaining there related two columns each.
This is a small extract of the data pattern I have and how it will need to show after alignment.

ONE AllowLapsedMotDates FALSE TWO AllowLapsedMotDates FALSE
ONE AllowTechToClaimHours FALSE TWO AllowTechToClaimHours FALSE
ONE AppointmentByAdvisor FALSE TWO AppointmentByAdvisor TRUE
ONE AppointmentOut FALSE TWO AppointmentOut TRUE
ONE AppointmentSafetyNet TWO AppointmentSafetyNet
ONE AutoAddCCToCDBooking FALSE TWO AutoAddCCToCDBooking FALSE
ONE AutoDiarySetup TRUE TWO AutoDiarySetup TRUE

Thanks in advance.