Combining data in several rows if a condition is met.

Hi there - back with another query!

I am trying to tidy up bank statements which have been subjected to OCR and saved in Excel. Due to the way the original statements are laid out, some of the transactions have details over several rows (could be two, three or more).

I need a macro/formula to do is combine the data so there is only one line per transaction.

In the attached example, the formula or macro should recognise if there is a blank cell in Column A at the start of the row and if this is the case combine the contents of the cells on the rest of that row and all the rows below it (until it comes across another row with an entry in Column A) with the last row above which didn't have a blank cell at the start of it.

I've probably not explained myself very well so have attached an example of the data I'm working with and what I'm trying to achieve.

Your help is much appreciated as always,

Ian

Hi Ian;

Watersev posted his solution while I was creating mine, but I'll post mine anyway.

I have not tested this so back up before trying it.

Please Login or Register  to view this content.

Hi,

One way

Please Login or Register  to view this content.