UNPIVOT EXAMPLE2

INPUT

 OUTPUT FORMAT1

 OUTPUT FORMAT2

SOLUTION

Table2 =

FILTER(

UNION(

SELECTCOLUMNS('Table1',"Company",[Company],"Date",[Date],"Vendor",[Vendor 1],"Charge Type",[Charge Type 1],"Charge",[Charge 1]),

SELECTCOLUMNS('Table1',"Company",[Company],"Date",[Date],"Vendor",[Vendor 2],"Charge Type",[Charge Type 2],"Charge",[Charge 2]),

SELECTCOLUMNS('Table1',"Company",[Company],"Date",[Date],"Vendor",[Vendor 3],"Charge Type",[Charge Type 3],"Charge",[Charge 3])

),

"Vendor"<>""&&"Charge Type"<>""&&"Charge"<>"")

TO DOWNLOAD PBIX FILE CLICK ME