Forum

Steven Vaughan
@srv1990
Eminent Member
Joined: Jan 5, 2022
Topics: 5 / Replies: 10
Reply
RE: Unstructured Table - Take Name from Row and Put on new column and individual Rows

Thank you for this. Your skills are clearly way beyond mine as I would have never figured that out. I agree the output is not optimal and unfortuna...

1 year ago
Forum
Reply
RE: How to just get the Month and Date from PowerQuery

Phil, that worked perfectly. Thank you for helping. I do have anothe question. I dont know if its appropriate to continue with anothe question in the...

2 years ago
Forum
Reply
RE: How to just get the Month and Date from PowerQuery

Sorry Phil for missing that step. Here is that screensoht. I am not sure if its helpful or I have given you enough information but if you have time ...

2 years ago
Forum
Topic
Reply
RE: PowerQuery: Calculate Aging Buckets

Hi Riny, May I please ask one more question. I would like to create a count through the following logic. If Age of Account is greater than 5 days...

3 years ago
Forum
Reply
RE: PowerQuery: Calculate Aging Buckets

Riny, I applied your solution but I just realized that I will have problems in the future, not with the solution provided, but with my process. T...

3 years ago
Forum
Reply
RE: PowerQuery: Calculate Aging Buckets

Thank you so much for taking the time out of your day to help me.

3 years ago
Forum
Reply
RE: PowerQuery: Calculate Aging Buckets

My apologies. Let me try again. Excel Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20704) 64-bit

3 years ago
Forum
Topic
Forum
Replies: 9
Views: 370
Reply
RE: Power Query Transform: Header Rows Repeat Until Next Header Adjacent column

Hi Riny, I am sorry but I just cannot get it to work. It must be something trivial that I am missing. I think I fixed the connection to the tab...

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

Riny, I placed the formula in but it says it cannot find the excel table. I tried both MyData nd PS Detailed. I think maybe it is how I am pulling i...

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

Hi Alan, First of all thank you for your response but I think I have not done a good job explaining this. It is not only Salaries and Wages it will c...

3 years ago
Forum