View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
alish alish is offline
external usenet poster
 
Posts: 25
Default Excel Tables - Cross tbl tp Reg tbl

Hello, Can any one help me with my dilemma he I am tring to convert my
"cross-table" looking table to a regular table, see below details:

"cross-tbl"
clmn A clmn B clmn C Totals 2008 Totals 2009 Totals 2010
Info1 data data $$$ $$$ $$$
Info2 data data $$$ $$$ $$$
Info3 data data $$$ $$$ $$$

I want:
clmn A clmn B clmn C colmn D Value
Info1 data data Totals 2008 $$$
Info1 data data Totals 2009 $$$
Info1 data data Totals 2010 $$$
Info2 data data Totals 2008 $$$
Info2 data data Totals 2009 $$$
Info2 data data Totals 2010 $$$
Info3 data data Totals 2008 $$$
Info3 data data Totals 2009 $$$
Info3 data data Totals 2010 $$$

Please help. I tried Pivot but it would show only once of Info and the two
datas.
Thanks in advance.