Excel - transposing certain cells in a row of data

I have an excel spreadsheet, similar to below, with sets of two rows which are identical (other than column 3 and 4). Some rows do not have an identical consecutive row (in this case row 3). For each set, I would like to transpose column 3 such that it looks like the second spreadsheet that I have copied in.

Y X 2 FALSE Y X 1 TRUE

C D 5 TRUE

E F 6 FALSE E F 7 TRUE

i.e I would like to combine the two identical rows, whilst transposing column three in order to keep the two different numbers. For single rows, the TRUE/FALSE in column 4 should indicate which column it should be transposed into. It should look similar to this: Y X 2 1

C D 5

E F 6 7 I do not have a lot of experience with excel but any help would be appreciated. I have hundreds of rows of data like this, so cannot do this manually.

Many thanks.

Recent Questions...