Layout a sample in Excel of what data you're trying to capture and what it should look like. Your sample above isn't very practical since you've stripped out all the data that might help identify what's actually needed here, so you need to mock up your final layout.

Use a text file with more data in it, and fill out your sample with the answers so we can see what goes where.