Thread: create a source table from a special pasted value dynamic crossed table
View Single Post
  #1   Report Post  
Posted to microsoft.public.fr.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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.


Reply With QuoteReply With Quote