Indexing data in a table

[John_Gault]

Hi All. I have a table (columns and rows) with only one data cell in use per each row under a specific column header. Think cartesian plane and coordinates. What I need is a formula that will allow me to highlight the entire table (data cells and blank cells alike) and spit out a list of all the entries on a separate sheet. So basically consolidating the data entries in various spots within the table into just a plain list of entries. Thanks in advance!!

 

[sheetspread]

Sounds like you want this:

http://www.mrexcel.com/forum/showthread.php?t=578347

 

[John_Gault]

Thank you. That was very helpful.