WesleySon

61 - Creating variables in Power Query, using inner queries

29 - Replace the values in a column on a condition (Power Query)

21 - Grab URL and title from all browser tabs (Power Automate Desktop)

61 - Using a calculated table as a list of eg definitions

51 - Dealing with tables with varying column names and number of columns

47Python.2 - HoloCure Collabs tool, using python and pandas

63 - Fixing the Formula.Firewall-error (Power Query)

07 - Filter a table using a variable (VBA)

59 - Inner query (Power Query)

27.1 - Split a table into tables with 50 rows (Power Query)

69 - Function scope in Power Query

Factorio, a train stop with dynamic train limits

64 - Use VBA to update queries, and measure the time it took

84 - Storing and accessing metadata, eg count rows of steps (Power Query)

79 - Handling a weird data structure (blanks and transpose) (Power Query)

64.1 - Time to update a query, pure M

Oops, all ants

97 - List Generate

66 - Playing with lists in Power Query

Factorio, having a train deposit to multiple stations

78 - Fixing spelling mistakes, Text Replace vs If (Power Query)

79 - Function to turn weeks into years and months (Excel, Excel 365 and VBA)

80 - Recursion in VBA (find the next valid day)

81- Aggregate, to e.g. find the next birthday (Excel)

79.1 - Python, Weeks to years and months

71 - Indirect

68 - Creating a cumulative sum column in Power Query

73 - Making an Excel sheet Very Hidden

72 - Dynamically updating a title + changing y axis (Power BI)

65 - \d{3} regex in Power Query

37 - Removing duplicates ignores your sort order (Power Query)

24 - Group by and Text Combine in Power Query

47SQL.1 - HoloCure Collabs tool, using Postgres and SQL

10 - Count duplicates (Power Query/Pivot table/VBA)

61 - Creating variables in Power Query, using inner queries

86 - Split columns, varying number of columns (Power Query)

75 - Recursion in Power Query

76 - As and Is (Power Query)

49 - Playing with Summarize and max sales (DAX)

83 - Days between, remove weekends (Power Query)

48 - Playing with Summarize and Groupby (Power Pivot)

58 - Using CalculateTable to simulate slicers (DAX)

47SQL.2 - HoloCure Collabs tool, using Postgres and SQL

67 - Cumulative sum, List Generate and function scope

53 - Print a table, then load it

12 - Using RegEx in Excel (VBA)

01 Using Power Automate to log on to your Runescape account

26 - Combining steps into one step in Power Query

18 - Archive table(s) with Power Query (Excel)