Last seen: Jul 8, 2026
Not sure I follow but my first question would be why you don't append all the tables (in Excel or with PowerQuery) and create the pivot table from the...
It's a bit of coding and works for this small example but I can't guarantee it will work on your real data set. Have a look at the attached file and s...
Not sure what you are trying to achieve but to focus just on your question re Pic 5, when you do a merge you need to identify the key columns in each ...
Hi Jay, The file was not attached. Please try again and don't forget to press the "Start Upload" button.
Hi Lea, I imported the cata via the legacy "From text" option. Split into columns by the comma. Then in the third step, mark each of the columns a...
Google drive wouldn't let me download the file so I replicated it by copying and pasting. You are aware that you can upload an Excel file to the forum...
I assume that the number 200 in C4 of the file you attached should in fact be 250, in order to be consistent with the other ranks. If that is correct,...
Hi Jose, Perhaps I haven't fully understood your intentions but based on what you described in your example I believe such a recursive LAMBDA funct...
Hi Albert, You would have to introduce a grouping element so that Excel knows which GL accounts belong together. Maybe you can do that by taking th...
Hi Edward, I had a good look at your schedule and believe that XLOOKUP is not going to do the job. Perhaps you want to consider Power Query. Then i...
Hi Justin, Couldn't work with the file in the link as it connected to a source on your own computer. Though, I took the two tables (outstanding and...
Added another possible solution. See Custom2 query in the attached file.
Then I would opt for creating two separate tables. One for Names and one for Departments and merge them on the basis of an index column. Perhaps not t...
After splitting, transpose the table and then Table.FromColumns. See attached in the Table1 query.
Hi, I note that you mimicked a Fill operation by manually entering formulae in column E (Projects) in the Table 1 (2) sheet. When you say that t...