I need to create a Query that will re-organize a table. It has been over 5 years since I was heavily using Query and Arrayformula's in Google Sheets and am not getting the results needed. Google Sheet example Data: https://docs.google.com/spreadsheets/d/1YI1mPJqL8x0GfxMSE9K2xCNzwi...
Hello experts, I still learn how to do transpose in excel. Until now, I still do some of it manually I want change this table into this table Thanks ! Setup is not ideal but there might be something to do (not sure yet) @ChristoNindyoVNS70 Data from picture didn't take kindly to ...
{{"Ticker", type text}, {"Date", type date}, {"Value", type number}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.ToText([Date],"dd-MM-yyyy")), #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1"...