Un-summarise data

[Richard Black]

Hi,

I have some spreadsheets with data in a summarised layout - columns for
dates, rows for courses and individual cells having a yes/no value. Is
there a way of writing the data into a new sheet in non-summarised form - eg
1 column for date, 1 for course - so that it can be exported to a database?
I have done VBA programming in Access, but don't know where to start in
Excel.

TIA,

Richard

 

[Debra Dalgleish]

To restructure your data, you may be able to use the "unpivot' technique
described by John Walkenbach:
http://j-walk.com/ss/excel/usertips/tip068.htm