create a source table from a special pasted value dynamic crossed table

[Arthemus]

How to re-create an original doc Excel with only a Dynamic Crossed tab?

Example :
With this :
E F G H
A 2
B
C 3
D 1
E
F 4
How to get this :

A F 2
C G 3
D E 1
F H 4

Thanks for your suggestions.

 

[Tom Ogilvy]

Try this link to John Walkenbach's site:

http://j-walk.com/ss/excel/usertips/tip068.htm