Database Structure

Hi,

Please be patient with me! I'm looking for the best way to structure a database. Here is a snapshot of a simple way to enter the data

Master Part # Competitor Name Competitor Price Competitor part #
123 Brand X 12.34 abc
123 Brand Y 8.85 xyz
456 Brand Y 12.86 def
456 Brand Z 7.34 fed
789 Brand X 7.95 qwerty
789 Brand Z 23.40 azerty

Ultimately, I want to be able to present the data under this format (Spreadsheet style) and export it to Excel.


Competitor X Competitor Y Competitor Z
Master Part # Part # Price Part # Price Part # Price
123 abc 12.34 XYZ 8.85



I'm opened to suggestions...

Should I simply structure the table the way I want the final result to look like?

Thanks