power query editor

Hi I want to use Power Query to pivot a set of data, but instead of the value cell being a number, it is text. I need to turn this: into this: This is just an example of how the data is setup, using PQ does work for this data, but when I try it with my actual data I get the...

Hi All. I am trying to create a spreadsheet which takes employee swipe times onto a site and gives how many hours they have worked. The format I have gotten it to gives me their name, date and entry on one row and then name date and exit on the second. But how can I combine these into a...

Hello everyone, In order to extract Data from SQL i have been using Queries. However, now i want to extract from a specific Database that is so large that it will never "refresh." My solution was to use a connection instead of a query. in the power query editor, i had this string in the...

Table1 Name Others Person A I am interested in doing calculus and trigonometry Person B coding, making websites Table2 Column A Subject category websites, mobile application, .. etc Information Technology mathemathics, calculus, trigonometry Math Column A are all the different...

Hi Everyone, I am using power query for the very first time and facing an issue in developing a formula of SUMIFS. The formula will be =SUMIFS($T$2:$T$1048576,$D$2:$D$1048576,D2,$W$2:$W$1048576,W2)/XLOOKUP(W2,VEH!D:D,VEH!E:E) Could you please assist to develop the formula in power query...

I am adding a column to get the quarter number, which I understand. I have as: = Table.AddColumn(#"Added Custom2", "QTR", each Date.QuarterOfYear([Package Effective Date])) However, I would like each to have 'QTR' also next to the number. So: QTR 3 QTR 2 QTR 2 ... How would I edit to also...

Hello, I'm trying to text in the advanced editor with a cell reference from a sheet in my workbook. I'm constantly having to manually update the advanced editor in 25 different tables which is taking me ~30minutes to run a report. Is it possible to do a cell reference for this? I've highlighted...

Hello, I would need an Excel Expert to assist me. I have two Excel reports : - Report of the payment - Customer Nationality The only unique identifier in the both of them is the CC numbers. I need to match those two reports using the CC numbers as unique identifier and add the column of the...