
Last seen: Aug 5, 2025
Here is the revised code let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled ...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled Down" = Table.FillDown(#"Trans...
Look at this link to help you with your VBA coding.
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Future Month ", type any}, {"M...
An alternative is to unpivot your data with Power Query let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type1" = Table.TransformColumnTypes(Source,{{"Salaries & Wages", type te...
crossposted:
Will there ever be more than three columns with numbers between 1 and 4?
Is this the result you would be looking for in the attached. If so, then this Power Query Mcode should be sufficient. let Source = Excel.CurrentWo...
Have you added the original data to the Data Model. This will increase the size of the file.
Would be extremely helpful if you uploaded a sample file of 10-15 records for us to work with.
Another means is to create a column that is the month number. Then Group By the Month for a Max Date Duplicate that query and remove the last step ...
Mcode let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"Attribute"}, {{"Data", each _, type t...
No file attached. Please try again.