Last seen: Jun 25, 2026
@tcg4apple Could you please clarify your intentions? what should be 'auto generated' and how would that be affected by the number of days in a parti...
@hutchdjr The script I gave you earlier selects "Name" and unpivots all other columns. If want the first 11 columns to stay in place and all others...
@hutchdjr Since you asked for a table that you can use to create your own pivot tables from, the following PQ script will do just that. Point the So...
@pakayak On the Data ribbon you'll see "Queries and Connections" (i.e. PC not Mac) then on the right hand side a side bar will open with the qu...
@ld107 Then I would revert to my original solution and add lists on top of each other. So, create one long table with all the columns you mentioned an...
@ld107 Add lists towards the right of your 'wide table' and be sure to give them unique names. Press Refresh All on the Data ribbon and the 'long ta...
@ld107 The set-up is slightly different from the file we worked on earlier. The attached file contains a simple PQ solution that should work for yo...
@pakayak Thanks for the files. Not sure what I'm looking at, though. My guess is that in the BOM file you have assembled (as an example) 2 products me...
@alanr The data sample is very small with only one trip and two projects. Assuming that your real data is much larger I would recommend that you sta...
@tk_aus Yes it will be visible to all and understand your concern. That's also why I'm not comfortable to give you my real e-mail address. The one bel...
@seizal_casper Thank you for your engagement to help resolving old questions in this forum. In this particular case, however, I believe your answer...
@tk_aus Did you perhaps change the way you entered the transactions in the Transactions table? For instance copy/paste dates, descriptions and amoun...
@pakayak Understand, but this forum has no private messaging. My involvement here is limited to solving relatively simple issues that don't take mu...
@pakayak OK, but that is just one BOM. What's the finished product? A kayak, I suppose. The template you referred to is designed to cope with orde...
@pakayak I believe that the template wasn't designed with a production cycle in mind where parts are assembled into finished product. It would add q...