Ok. Here is what I did. Using Power Query which in your version is on the Data Tab and called Get and Transform. Highlighted table and brought into PQ. Once in PQ, highlighted first column and clicked on Unpivot --> Other columns. Filtered the Value Column to uncheck 0 values. Close and Loaded to Excel. Mcode below and file attached. Note: the highlighted table that is imported is called Table1 in my scenario. If you have named it something else, then you will use that name.
If you are interested in learning more about PQ, then click on the link in my signature and also, the book--> M is for (Data) Monkey is available on Amazon. A great Primer.
Bookmarks