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

Try this link to John Walkenbach's site:

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

--
Regards,
Tom Ogilvy

"Arthemus" wrote in message
om...
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.