Using a formula (I think) to copy 'raw data' into a 'scatter chart data' sheet

Hi all,
I have a problem which requires a little help.
I have some raw data as follows:
Column A = Programs
Column B = Rating
Column C - Index

* This raw data is taken from a program and ends up in these columns.

What I was to do is chart this on a 'scatter graph'. In order to produce the necessary 'scatter graph' I need to arrange my data so that:
Column A (Programs) run 'vertically'
Column B (Ratings) run 'horizontally'
Column C (Index) run 'diagonally'

* Please see attached example

My question is: Is there a 'If' formula (or something similar) to display the 'Index' figures in the correct horizontal/vertical cell so that I can chart the figures? Otherwise, this is an extremely labour intensive task to put the figures in manually.

Originally Posted by bsmith69

Hi all,
I have a problem which requires a little help.
I have some raw data as follows:
Column A = Programs
Column B = Rating
Column C - Index

* This raw data is taken from a program and ends up in these columns.

What I was to do is chart this on a 'scatter graph'. In order to produce the necessary 'scatter graph' I need to arrange my data so that:
Column A (Programs) run 'vertically'
Column B (Ratings) run 'horizontally'
Column C (Index) run 'diagonally'

* Please see attached example

My question is: Is there a 'If' formula (or something similar) to display the 'Index' figures in the correct horizontal/vertical cell so that I can chart the figures? Otherwise, this is an extremely labour intensive task to put the figures in manually.

In cell B210 put

=IF(B$20=$B3,$C3,"")

and formula-fill that to cell N33 (whole grid)

This relies on equal film names D3 & D20 lists.

---