Thank You all for the valuable contributions. None of the suggestions helped unfortunately. I think that's due to the very poor quality level of data in the Excel file. As I am not able to influence production of this file I decided to chang the code logic and get rid of this particular data transformation altogether. Thank you! ... View more

Yes, its one of those things that non-technical people just don't understand.  Its all well and good the management getting flashy colored spreadsheets and thinking they actually do something by pivoting it.  The simple fact is though that Excel is not a data transfer format, or a database, or a data capture, or data analysis, or and IDE, or anything else.  Its an unstructured, uncontrolled, mess of an application and really has no place on any computer.  ... View more