- PQ - Running sum
- PQ - Text.Format
- PQ - Consolidate two tables
- PQ - Median of dates
- PQ - Count selected day between dates
- PQ - From trash to 1NF
- PQ - Get actual worksheet functions list
- PQ - Risk rank
- PQ - Count word in record
- PQ - Total hours in decimal format
- PQ - Expand dates from first to last
- PQ - Running Total start over
- PQ - Return label and header for max value
- PQ - Details for selected country
- PQ - Remove columns contain null on the end
- PQ - How much was sold in an hour
- PQ - Number grouped rows
- PQ - Random questions limited (52)
- PQ - Sort ascending values by minimum value from each group
- PQ - table reorganization
- PQ - Merge two tables with subtraction
- PQ - UnZip an use Content in Power Query
- PQ - Table.Partition - split single table to three tables by year
- PQ - Table.Split - split single table to three tables by year - less flexible
- PQ - Non standard approach to Counting Distinct entries by group
- PQ - Numbering duplicates in ascending order
- PQ - How to extract first and last time from text in single cell
- PQ - Distinct vs Unique
- PQ - Split multiple columns at the same time
- more about PowerQuery aka Get&Transform (links)
- PQ - Sum columns with null values
- PQ - Extract initial letters string from longer string with different length
- PQ - Sort columns and rows
- PQ - Add zero if there is a single digit after last delimiter (here: / )
- PQ - Calendar with user defined StartDate and EndDate
- PQ - Count sub-levels in Pivot Table
- PQ - Summary from template in single workbook
- PQ - Calculate variances based on different model selections
- PQ - Sum values for each label from defined range of columns
- PQ - How to get Total via Power Query
- PQ - Return header(s) of column(s) for maximum average
- PQ - Transform data from vertical to horizontal with Table.FromRecords
- PQ - How many Scores of 80 or more have been obtained by Subject - with Pivot Table
- PQ - Expand IP address range to individual
- PQ - IP C class generator
- PQ - extract 8-digit groups from a text string into separate columns
- PQ - Distinct keywords from text
- PQ - How to append three or more tables with different headers (first table has proper headers)
- New old qeustion
- PQ - Split multiple columns into rows at once
- PQ-Get each student list from each subject
- PQ-compare two columns A and B in the same table then return unmatched
- PQ - Table replace values
- PQ- End of previous month
- PQ-Transposing Data and Splitting Cells
- PQ-text split multiple columns at once
- PQ - serpentine volleyball seeding
- PQ - How to add columns from a list? each item in a list means a new column
- PQ-Auto filling information
- PQ - Extracting data from range
- PQ - Concatenation by condition (XL2016)
- PQ-transpose data from several lines to one column
- PQ-Enter blank row after group of cells or empty cell is detected
- PQ-how many last rows to show determined by single row table
- PQ - transform text string to proper date
- PQ - simple example of List.Intersect()
- PQ - tip of the day
- PQ-How to insert comma between every character
- PQ - Fridays between dates for whole year
- PQ - List Prime
- PQ - Restart numbering with table
- PQ - restart numbering
- PQ - search item return category
- PQ-search for data with just a few letters from a data table
- PQ - multiple replacement using List.Generate()
- PQ - Cleanup data with several conditions
- PQ - Evaluate
- PQ - Letter count in each word of text
- PQ (PT) - Text value in an interference matrix
- PQ - Grouping columns in rows and get data marked by x together
- PQ - Grouping rows with different data type
- PQ - from excel workbook with/without promote headers
- PQ - counting rows filtered and after filtering