Hi,

I would like to know if there is an inteligent way of converting a table as appear in sheet "Before" of the attached file to a table as appear in sheet "After".

I was able to achieve the "After" result only by splitting the table into 2 tables, 1 with Month and Materials columns, and another with Month and Purposes columns, unpivoted both (selecting Monther and Unpivot Other Columns), and than combined both tables into 1.

Regards,

Ayal Telem.