Thread: Data on multiple lines needs to be put into 1 line

Okay, so I'm not sure how to phrase the title, but here's what I need

On the attached spreadsheet, there is a rent roll for an apartment building. Column A shows the unit, then column I shows the different charges for that unit. For example, on line 2, unit 101D has two charges, Rent and PEP. As you can see in the blue highlighted area I have created formulas to read the different charges. they HAVE to remain separated/broken out.

What I want to do is to have all the charges for that unit on the one line. So for unit 101D, the PEP fee would show up on row 2, instead of row 3 as it does now.

I'm guessing that I might need coding for it, as a formula may be too long and complicated, but I wanted to ask. Please help. I get rent rolls like this in ALL the time and it takes forever to go line by line typing everything in.

Thanks!