Condensing this?

[TRcifb]

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

[#2]

May I attach a file, in this forum?

[#3]

go ahead.