Sorting Data with a Common Variable

[braveduck]

Hello all,
I am new to the forum, hoping to find some help from Excel pros! Your help is greatly appreciated.

I have a large data set that is formatted as follows:
Screen Shot 2012-11-07 at 8.52.46 AM.png

I would like to reorganize this exact data so that it displays differently. I'd like to combine the common words in column A and common dates in column B to be my X and Y axis. The following graphic is a small sampling of how I would like to get the data:
Screen Shot 2012-11-07 at 8.55.50 AM.png

Thank you very much for your help.
Mike

[kbkumar]

Hi Mike,

Welcome to the forum.

It would be helpful if you could please upload a workbook with sample data.

Thanks,

[braveduck]

Sure thing. Attached is a sample part of the workbook. This is representative of what all of the data looks like.
Workbook-Data-Sample.xlsx
Thanks so much,
Mike

[kbkumar]

You can easily do this by creating a pivot table.

[Norie]

Mike

This could be done with a pivot table.

It would have the first column as the row header (Y-axis), the dates as the column header (X-axis) and the third column as a data field.

You would need to add headers for the 3 columns.

See the attached.