Hello,

We have a database system which exports reports in excel, but incorrectly. I want to know if I can use a formula to merge cells and ignore blank rows.

Each individual reports are distinguished by a name. However, the "Look Behind notes" sometimes break into several cells and lines up in Column A. This makes it very difficult to read and edit completed notes for several hundred people.

I basically need a formula that would set a condition for when a new report starts (I was able to create one in Column E since any entry which begins with a "<" indicates a break from the previous row. I also need a formula to line up data in F,G, H, and I have shown.

It would be great if the the data can be lined up sequentially, insteadMerge notes.xls of having blanks rows between reports. Thanks.