Table = FILTER( UNION( SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column1]), SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column2]), SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column3]), SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column4]), SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column5]), SELECTCOLUMNS('Table1',"Name",[Name],"Date",[Date],"Column1",[Column6]) ), [Column1]<>"")