Forum

Alan Sidman
Alan Sidman
@alansidman
Moderator
Member
Joined: Oct 18, 2018
Last seen: Jun 30, 2025
Topics: 3 / Replies: 230
Reply
RE: Unable to read certain web pages to import into Power Query

Here are some potential reasons you may be having difficulties. This listing is not exclusive as there may be more issues. 1. Dynamic Content &...

2 days ago
Forum
Reply
RE: table skipping rows

Cannot replicate your issue. When I place the cursor in the next row and enter data, it goes to the next row. Am I missing something?

3 days ago
Reply
RE: PQ-2025

You might find the following helpful. Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (wh...

5 days ago
Forum
Reply
RE: Cannot format Date in Table

Suggest you attach a sample file showing this issue so that we can evaluate it. Cannot manipulate data in a picture.

2 weeks ago
Forum
Reply
RE: Slicer does not hide items with no data

crossposting: and Please read this:-->

3 weeks ago
Forum
Reply
RE: Comparing Array Rows

A Sample worksheet with mocked up solution would be very helpful here. The worksheet should probably not have more than 20 records. No pictures as w...

3 weeks ago
Reply
RE: Pivot table overlap

Move your pivot table to a fresh worksheet. Apparently you have more than one PT on the same sheet and they are overlapping. If this is not the case ...

3 weeks ago
Reply
Reply
RE: Splitting a Column with codes and below the code numbers

Here is an alternative Power Query Solution

4 weeks ago
Forum
Reply
RE: Formula for a financial report with a number of options

It would be very helpful if you attached a sample file which is reflective of your actual file (no confidential material included). We can then work ...

1 month ago
Reply
RE: Loop Through List for Min/Max to Calculate Duration

See if this works for you let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each ([Pair...

2 months ago
Forum
Reply
RE: Loop Through List for Min/Max to Calculate Duration

If I understand correctly then, Power Query will do the work let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Ta...

2 months ago
Forum
Reply
RE: Evenly distribute Quantity across Fiscal year weeks?

We cannot manipulate data in a picture. Please repost your file as an attachment.

2 months ago
Forum
Reply
RE: New Date & Time when New Table record is created

CTL + ; will give you the current date CTL Shift + : will give you the current time

3 months ago
Reply
RE: IF Formula for Calculating Time

Suggest you post a sample workbook as an attachment. 8 to 10 records. Then mock up the expected solution for what your issue is. This way we do not...

3 months ago
Page 1 / 16