Forum

Cedric McKeever
@cmckeever
Trusted Member
Joined: Jan 20, 2019
Topics: 6 / Replies: 32
Reply
RE: Sorting

Hi, I believe Charles is right, I should have had two columns for address. I also, never thought of widening the rows, I'll try it out. T...

1 year ago
Reply
RE: Sorting

Hi, Thanks for taking the time to answer my question. The blank line is there to make it easier to read while I am walking around trying to co...

1 year ago
Topic
1 year ago
Replies: 7
Views: 117
Reply
RE: Move Data from one column to another column in PQ

I appreciate your help. You do a great job on here. There were so many problems with the PDF download into Excel that I decided to fix the rest ma...

1 year ago
Forum
Reply
RE: Move Data from one column to another column in PQ

Nice job, To answer your question, that is not an error, it is also a problem to be dealt with. As you can see in the Results table, that has t...

1 year ago
Forum
Reply
RE: Move Data from one column to another column in PQ

Hi, Thanks for answering my question. The table was downloaded from a PDF with 2900 rows, and some of the columns got mixed up. There are num...

1 year ago
Forum
Topic
Reply
RE: Challenge in power query

Hi,P Request 1 on 12/10/2023, the amount was 10 items. That is reflected in the Price table. Request 2, the amount was 20 items. However, in the...

1 year ago
Forum
Reply
RE: Uniform row height even after refreshing.

Hi, If Catalin solution does not help, which is unlikely, here is a solution on row height from ChatGPT. It sounds like you're using Power Query...

1 year ago
Forum
Reply
RE: Lookup at all sales data to inventory levels

I started looking at this in Power Query. It is not an easy solution and is probably beyond my capability. But I have a few questions. Are you go...

2 years ago
Reply
RE: Excel Array and Scan Button

Hi, To make the results spill across rows (i.e., horizontally) instead of vertically, you just need to adjust the dimensions of the array. Inste...

2 years ago
Reply
RE: How do you manage the order in which data is processed by reference queries

I'm sorry, but I am old, and my mind does not work fast. I still do not get what the final output should be. From what I understand this is the data...

2 years ago
Forum
Reply
RE: VBA Function: Results to spilling array created in VBA.

Something from ChatGPT: You need to return a 2D variant array for the function to spill in Excel. The function should be set up to work as an ar...

2 years ago
Forum
Reply
RE: How do you manage the order in which data is processed by reference queries

I see that there are several views but no replies. Maybe I am wrong but as I understand it if FF is at the beginning of the text, then you want a ret...

2 years ago
Forum
Page 1 / 3