Retreive Header Name and Value from a Data Table
I have data file and I'm trying to load data in an array based on a certain row Type Value. My function successfully finds the row but some of the cells on that row are empty. So I'm trying to filter out the blank cell and end up with a list that tells the actual header name (column) and the value in the row. Can anyone offer any suggestions?