Hi, all. I'm having some difficulty cracking a problem I've encountered. I have a large data set that I have pulled into Excel from a web scraper. I'm looking to consolidate rows but I can't seem to find a command or formula that gives me quite what I want. Here's an example of the situation:

ID Content Author
ID0001 Content written by Author #1
ID0001 Author #1
ID0002 Content written by Author #2
ID0002 Author #2
ID0003 Author #3
ID0003 Content written by Author #3
ID0004 Author #4
ID0004
ID0004 Content written by Author #4

I can get rid of the rows where there are no authors or content (Filter and delete), but then I want to consolidate the rows that have the same ID value, so that the content written and the author appear on the same row. The trouble is that the content and the author are not always misaligned in the same direction. Sometimes the author row comes first and sometimes the content row comes first.

I thought about trying to write a formula that compares ID values across cells and copies the values from the "Content" or "Author" column but I can't wrap my head around how that would look beyond comparing the cells in the ID column and returning a value for true or false.

Any options that you think I should investigate further?