VBA needed to extract specific data from data dump list

I've come up with a very crude solution to my problem that involves multiple vlookups, countif and left statements to get the data I need from this list, but the problem is these reports can run 35,000+ rows long due to the data in column F. So my formula bogs down the file and crashes excel when the lists get too long or I try to do other analysis. I've attached a sample list that gets exported from our management software.

All I want from this list is to get the person's name who created the log (cell A2, additional rows below) and the type of log they created (column E) extracted to another sheet. So the new sheet would have column A = Created By, column B = Contact Method.

Please help!

Thanks for the reply mehmetcik. Your suggestion would work if all the rows aligned and were consistent in the number of rows between "created by". Column F, creates random rows based on the length of the actual log, so doing a 1 for 1 formula leaves any given number of spaces in between. Also each person could have a different number of logs, so it could be 5 rows between people or 500. With all the merged cells in the file, random number of rows between log types and people, I'm looking for some way to find the pertinent data and extract it.

Correct no dates.

Thanks for the updated response mehmetcik. The formulas work, but it puts me back into the same situation I had in the beginning, potentially 30,000+ rows of information, using multiple formulas. I can parse the list down using the sort feature, to only pull the data I want from here, but this would be another step in a process that gets done several times per month. Ideally, I'm looking for a solution that breaks down the data dump and then pulls the relevant information over in a consolidated format that can be seamlessly transferred into a much bigger dashboard report.

This works great. Thank you.