View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Flatten a table to a list

To reorganize the data, you can use the "unpivot' technique described by
John Walkenbach:

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


Grangemb1 wrote:
How do I flatten a table into a list containing row value, column value and
intersection value?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html