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...
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...
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...
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...
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...
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...
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...
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...
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...
My pleasure. Good luck.
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...
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...
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...