Monday, July 26, 2010

Convert Table To List

This is a code I wrote to convert a table (values and headers) to a list, so it can easily be manipulated using pivot tables or loaded intro a database. I posted this two years ago on the excellent Ozgrid Forums, so it makes sense I share it here too. It was tested on Excel 2003, but it should work in 2007/2010. Let me know if it doesn't.