Help Creating a table with information from multiple columns and rows

Hello All,

This is my first posting so I'm unsure if my problem has been addressed. I am attempting to create a table that grabs information from Column F and G, that only has the value of "C" from Column B, but I need it sort out the Unique Values of Column "F" have the values that are with "F" in the "G" Column separated into individual columns. The values of the table changes weekly, and I am looking for help creating a formula or VBA module to help automate these changes. I've attached an excel sheet that shows what I'm trying to accomplish. If you have more questions I will attempt to answer to the best of my ability.

Cheers,
Acidking

Kinda hard to understand the last part of your request. Is this what you need?

Thank you for your help, its not quite what I was looking for. I think I found a solution but it eats up a bunch of RAM. Essentially it searches two columns for criteria and gives me the information from the 3 column. What I am looking for is a way to search the Steps column, against information in the Line and Category Columns. It would need to search Category column for all the values of C, then give me the corresponding line values filtering out the duplicates, and then creating a list of values that tie into the information that is is the Steps column at the same time as filtering out duplicates, but unique to each Line value.