How do I flatten a table into a list containing row value, column value and intersection value?
G Grangemb1 Oct 12, 2006 #1 How do I flatten a table into a list containing row value, column value and intersection value?
D Debra Dalgleish Oct 12, 2006 #2 To reorganize the data, you can use the "unpivot' technique described by John Walkenbach: http://j-walk.com/ss/excel/usertips/tip068.htm
To reorganize the data, you can use the "unpivot' technique described by John Walkenbach: http://j-walk.com/ss/excel/usertips/tip068.htm
