I've attached a sample workbook of the data that I need to be consolidated. My large workbook contains hundreds of names with multiple lines each. I need for all lines for each name to be consolidated in to a single line. The amounts listed in columns I through AE are all correct and in their proper positions. They simply need to be moved "up" so that they all align in a single row. Is it even possible to do this?

Thank you very much.