Remove duplicate values of sets of data vertically

Hi Excel gurus out there. So here is my situation.

I am working with data that comes in sets that is two cells wide and anywhere from 2-5 rows in height.
These sets are separated by one space in between them.
Ultimately, what I want to achieve is to remove any duplicate sets of these combinations. The most straightforward way I thought to do this would be to take these sets and lay them out in a single row (seen on the right side of my screenshot).
Remove duplicates should work fine if I am able to achieve this. I am not sure if there is an easier alternative.

Untitled.png
New Microsoft Excel Worksheet.xlsx

Hmmm, this is a tough one. I will think on it and ask the other Gurus

I like your solution cbatrody but I think the OP wants each set to be unique where a set is the total cells between blank rows. Your solution just pulls the rows that are unique. Correct me if I am wrong.

Got the solution..
check the attachment..
To know the logic of my algorithm..
Visit following link..
http://http://excel-buzz.blogspot.co...olumns-to.html

Vikas_Gautam,
Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

You should have posted the code for the solution to this forum.

Originally Posted by protonLeah

Vikas_Gautam,
Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

You should have posted the code for the solution to this forum.

How exactly is this rule to be interpreted in this case, with regards to the fact that Vikas's site is arguably more of a blog than a forum?

I ask since I myself have started adding a link to my blog (not forum!) in my signature.

What's more, how does the definition you give, from the Forum Rules section of this site, tie in with this, from the site FAQ:

"Signatures' contain information that you want to include at the bottom of all your posts. This might include pictures, links to your site(s), quotes, etc."

So as long as it's not clearly a forum (and one which is competitive to this site), then it's generally ok? If not, perhaps this forum should consider amending that rule to include the phrase "blog", or perhaps, to be on the safe side:

"Cross-promotion of, or links to, any site deemed competitive to this forum in signatures are prohibited."

though obviously that may cause a bit of a stir amongst members as to which sites are classed as "competitive" to this one.

Personally I have found material of educational (in Excel terms) value on Vikas's blog - if a link to his site is against forum rules, might we also exclude sites such as Chandoo, Contextures, etc.?

Hoping for clarification.

Regards

Vikas, your blog does not constitute a competing forum and your link is to free content, not commercial content. As such it is not a violation of rule #13. Your link in this thread is good. Whenever possible, provide the solution you're offering the OP in the thread itself. If the previously posted content on your blog accurately covers the posted question, then a well-meaning link is fine.

Thank you all for your continued care that our rules are followed for the benefit of all.