Condensing this?

I'm working with a program that exports data to look like this. Is there a faster way to condense this than going through it line by line?

I'm using Excel 13