Posted to microsoft.public.excel.misc
|
|
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
|