help with excel automation

The problem I have is the following. My company has recently begun using SAP, a program which I am sure many of you have heard of, which is capable of giving large amounts of updated data at any given moment. I can then grab this information and extract it to excel but the problem is that it is far from clear because it has a lot of redundant information and a lack of formatting. The idea is to try to find some type of clever way for me to be able to get this list and make it clearer with out having to go one by one fixing the formatting and information.

I thought about using a macros but the nature fo the information is ever changing so the length of the lists (I will attach an example) is ever changing. Maybe there is a way for excel to recognize when there is a space in between and that when it does to repeat the process.

I attached an example of what it looks like when I export the information to excel. Im open to all suggestions and I would like to thank everyone in advance for any help you can give me!

Sorry about that! I forgot completely to show what i wanted. Im attaching a file that shows what I would like it to look like