macro to select cells based on status of cells to left

Hi guys, sorry if my title doesn't clearly explain my problem, I'll try and do a better job here.

I have several spreadsheets that are several thousand rows each and they all have the same problem.

I copy and pasted the data from a website into a txt document and imported it into excel and I have the following problem.

Title | Description | Features
| Description | Features
| Description | Features
Title | Description | Features
| Description | Features

I need to get all of that information into 1 row for each title. I have a macro that allows me to manually select the relevant rows and it then combines them but since I have thousands of lines this is no longer practical.

How can I have a macro that selects a cell if the cell under title in the same row is blank and the automatically sends that through my other macro.

Thanks in advance for the help.

I have included a screenshot to demonstrate how my data.

and below is the macro I currently use.

I need everything to be in the correct row with the appropriate account.

Please Login or Register  to view this content.