Excel - derive detail from a cross tab

[EricNolan]

Sounds like a simple task. You have a multiplication table like you remember is grade school. Numbers down the left and across the top with the resulting values in the middle.

I want to create a new sheet that lists as follows:
Left Right Middle
1 1 1
1 2 2
1 3 3
2 1 2
2 2 4
2 3 6

Can it be done?

 

[ETID]

I need to see an example of the orig. data to get the whole picture....

 

[EricNolan]

Here is the base data:
1 2 3 4

1 1 2 3 4

2 2 4 6 8

3 3 6 9 12

4 4 8 12 16

Here is what I need to show:

1 1 1
1 2 2
1 3 3
1 4 4
2 1 2
2 2 4
2 3 6
etc.

Thanks

 

[ETID]

I'm built too low for this one...(it's over my head), I can't see the relationship, could you supply more detail?

 

[logius]

Think of the first table as a grid. The Top row is the X-coordinate and the first Column is the Y-coordinate. Where the two coordinates meet, he's plotting the product.

Ex: 1 x 1 = 1
1 2 3 4
1 1 2 3 4
2 2 4 6 8
3 3 6 9 12
4 4 8 12 16

or: 3 x 2 = 6
1 2 3 4
1 1 2 3 4
2 2 4 6 8
3 3 6 9 12
4 4 8 12 16

I'm working on a solution for this but I have a few other things to do first.