let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Emp ID", type text}, {"01-Sep", type text}, {"02-Sep", type text}, {"03-Sep", type text}, {"04-Sep", type text}, {"05-Sep", type text}, {"06-Sep", type text}, {"07-Sep", type text}, {"08-Sep", type text}, {"09-Sep", type text}, {"10-Sep", type text}, {"11-Sep", type text}, {"12-Sep", type text}, {"13-Sep", type text}, {"14-Sep", type text}, {"15-Sep", type text}, {"16-Sep", type text}, {"17-Sep", type text}, {"18-Sep", type text}, {"19-Sep", type text}, {"20-Sep", type text}, {"21-Sep", type text}, {"22-Sep", type text}, {"23-Sep", type text}, {"24-Sep", type text}, {"25-Sep", type text}, {"26-Sep", type text}, {"27-Sep", type text}, {"28-Sep", type text}, {"29-Sep", type text}, {"30-Sep", type text}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Emp ID"}, "Attribute", "Value"),
#"Merged Columns" = Table.CombineColumns(#"Unpivoted Other Columns",{"Emp ID", "Attribute"},Combiner.CombineTextByDelimiter(":", QuoteStyle.None),"Emp ID : date")
in
#"Merged Columns"