Hi Philip, thanks for your reply and suggestion However, seems like my excel version do not recognise Splitter.SplitTextByCharacterTransition ...
Hi, G3=MIN(C5:C107) H3=MAX(C5:C107)
Hi Amien Please see whether you can access to my PQ solution Result1 let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Added ...
Hi in Power Query Editor, format to time, create a custom column Time.ToText([Time], "hh:mm") let Source = Excel.CurrentWorkbook(){[Na...
Hi Robert Yes please, a sample of your original Datetime column and also with column of Month, with the error that you mentioned
Hi Catalin Sir, Finally with your tips and guidance, managed to code it Thank you for your patience with me Cheers !!!!
Sorry Catalin After replacing it = Table.ExpandTableColumn(#"Added Custom", "Custom", {Table.ColumnNames(#"Added Custom")}, {Table.ColumnNames(...
Hi Catalin however for my case, I require to find a solution to automatically insert "Column4", "Column5" whenever the source file append new data...
Hi Philip, thanks for your response, I know Pivot table can do the job but however to figure out why the expanded cannot be automated, sometimes we...
Hi Philip, my user wanted to view in a pivot table format for dates, that is header with Date1, Date2.............. How about mass changing of ...
Hi Philip Thanks for your response and explanation