Forum

Alan Sidman
Alan Sidman
@alansidman
Moderator
Member
Joined: Oct 18, 2018
Last seen: Aug 5, 2025
Topics: 3 / Replies: 233
Reply
RE: Multiple Corrections to Table, requires pivoting, transposing, perhaps pivoting some more?

Here is the revised code let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled ...

3 years ago
Forum
Reply
RE: Multiple Corrections to Table, requires pivoting, transposing, perhaps pivoting some more?

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Transposed Table" = Table.Transpose(Source), #"Filled Down" = Table.FillDown(#"Trans...

3 years ago
Forum
Reply
RE: VBA Code

Look at this link to help you with your VBA coding.

3 years ago
Forum
Reply
RE: Power Query: Sort Date Headers in Chronological Order.

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Future Month ", type any}, {"M...

3 years ago
Forum
Reply
RE: Stack data into one column?

An alternative is to unpivot your data with Power Query let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...

3 years ago
Reply
RE: Power Query Transform: Header Rows Repeat Until Next Header Adjacent column

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type1" = Table.TransformColumnTypes(Source,{{"Salaries & Wages", type te...

3 years ago
Forum
Reply
RE: Extract a value and return column header

Will there ever be more than three columns with numbers between 1 and 4?

3 years ago
Reply
RE: Calculation of cumulative hours

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...

4 years ago
Reply
RE: Reduce Size of File

Have you added the original data to the Data Model. This will increase the size of the file.

4 years ago
Forum
Reply
RE: Split digit to non digit in Excel 2016 using qury

Would be extremely helpful if you uploaded a sample file of 10-15 records for us to work with.

4 years ago
Forum
Reply
RE: Grouping by latest date in each month

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 ...

4 years ago
Forum
Reply
RE: Refer to above cell in Power Query

Mcode let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"Attribute"}, {{"Data", each _, type t...

4 years ago
Forum
Reply
RE: calculation question

No file attached. Please try again.

4 years ago
Page 11 / 16