I’m reading a data table, creating a dictionary for all non-null fields, then writing a workbook using the dictionary.
I’m having two problems. For one, my dictionary is not skipping null fields. I wasn’t having this problem yesterday and I can’t quite seem to figure it out. I’ve tried “isNot Nothing” and does not “Equal(”")", but neither are working now.
Also, when I’m writing the new workbook from the dictionary, I’d like to write it like a normal table. So write A1 as the key, with A2 as the value, then continue down the rows with more key and value pairs. At the moment, I can only get it to write the key and value in the same cell with brackets around them.
WriteDictionary2.zip (20.8 KB)
Any assistance is much appreciated!