My idea is all data in one sheet with adding month column.
In some other column "G" extract unique item with formula "G3"
Formula:
=IFERROR(INDEX(Item,MATCH(0,COUNTIF($G$2:G2,Item),0)),"")
Horizontally value & month with formula "H3"
Formula:
=IFERROR(INDEX(Table1[Value 1],MATCH($G3&H$2,Table1[Item]&Table1[Month],0)),"")
In "L3"
Formula:
=IFERROR(INDEX(Table1[Value 2],MATCH($G3&L$2,Table1[Item]&Table1[Month],0)),"")
In "P3"
Formula:
=IFERROR(INDEX(Table1[Value 3],MATCH($G3&P$2,Table1[Item]&Table1[Month],0)),"")
paste up to certain column. Ensure press shift+ctrl+enter.
Look attach file.
Bookmarks