To translate complex text into columns

[otobus]

Hello there

I have a csv file. File can come to me quite confused.

I want
Titles in the top row,
Alt form of a letter to the sender field

For example, e-mail sender has sent a third person;

Whether the sender. Areas B, C, D,
I want results
Date Posted Areas
12.30.2015 B
30.12.2015 C
12/30/2015 D

As you can see in the sample file size of mail to arrive to excel in areas such as IP number. If this is our only send me e-mail the results to date and I need to find adequate results as the sample file is not but.

I would like to draw your attention to a few title
• There are both sending and receiving B1 column. There are areas in subsequent columns.
• Fields finished the other fish begins.
• Number of Mail variable field can take a lot of mail to 50 people. So the number of fields in the above example was 50 though. 50 lines were open. Other kolner values ​​in the same condition that ..

I thank you in advance for your valuable support.