Forum

Hello, If you remove the AllYears query, you can then delete those two columns in the table and then add the AllYears table into Power Query again....

Hello, I would go with Power Query too, but a formula version I would use is =SUM(('Sheet 2'!$E$4:$P$2558)*(('Sheet 2'!$A$4:$A$2558=$A3)+('Sheet...

Hello, Is it Power Query Custom Data Types you are looking for? Br, Anders

Hello, If you attach a sample file with some data it would be much easier to give you a correct answer. The XLOOKUP function can return values in m...

Hello, According to information at Microsoft support pages. (As per date of this post) Python in Excel is now available to Enterprise and Busi...

Hello, I had lots of issues with the dates in your sample file, so I took the liberty to make a variant of it. You need to check if the numbers are...

Hello, You can use ISTEXT instead for such scenario. Br, Anders

Hello, It seems the sample file didn’t get uploaded. Br; Anders

Hello, =TEXTJOIN(",",TRUE(),IF(($I$3:$O$3)*(ISNUMBER(I6:O6))<>0,($I$3:$O$3)*(ISNUMBER(I6:O6)),"")) Br, Anders

Hello, I assume you have Microsft 365. In G6, paste in following formula and then copy down. =TEXTJOIN(",",TRUE(),FILTER($I$3:$O$3,ISNUMBER(I6:O...

Hello, Check out the tip from Catalin in this post, it should help you to load data into Power Query regardless. Br, Anders

Hello, Just checking the support page Cognito Forms API - Cognito Forms should give you the answer you are looking for. I added some extra spaces i...

Hello, I asked Copilot. Don't know if it works though. Copilot Genererar svar åt dig… Skickades av Copilot: It look...

Hello, Have you considered using Power Query to load your data? You don't mention how your data is coming in to the workbook, other than you want t...

Hello, Perhaps not the answer you want, but is it possible adjusting the height and width beforhand? In that way the expected data is shown as expe...