User Profile
MHulten
Copper Contributor
Joined Oct 27, 2021
User Widgets
Recent Discussions
Re: Transpose rows and join with row header using formula
I haven’t used PowerQuery. The intention is to distribute this as a template. I can’t have any inbuilt dependencies other than the version of Excel that is distributed with the E5 license. Would this work with PowerQuery?2.3KViews0likes5CommentsTranspose rows and join with row header using formula
Hi! I need to use a formula (not macro) to transpose a table and return another table based on the row header and each individual column value. Optionally a textjoin of the combination cold work. Note that the source data may be defined as a table, range, or stay as "normal" data in the sheet based on what would be convenient. I have appended an example sheet with the source data in A1:D4 and example output in F1:G8 with the textjoin option in I2:I8. The source data may grow downwards but the number of columns is static. I'm using Office 365 with an E5 licence. BR /MatsSolved2.5KViews0likes7CommentsRe: Is it possible to create a grid based on dynamic arrays?
Riny_van_Eekelen sorry for ghosting you (but it is halloween after all... 😉 ). My intention is to have the user enter the X'es manually based on the analysis at hand. In other words, there will be no formula that takes care of this work. Using a non dynamic grid (i.e. static text in cells) this is entirely possible, but that would mean having the user perform manual copy and paste, or using a macro when the source ranges change. I want to avoid both of these options. Another option would be to have a table with two columns side by side. Then having listboxes with the ranges as source, where the user can set the relation. But when the ranges grow this option looses in usability. BR Mats1KViews0likes1CommentIs it possible to create a grid based on dynamic arrays?
I'm trying to create a simple grid that holds referential information between two tables (Person and Resource). The pasted grid below is to give an understanding of what I wish to accomplish. Starting state: Anna =TRANSPOSE(tblResource) Tom Jet Bike Train John =tblPerson[Person] Anna X Tom X John X Jet Bike Train Adding 'Boat' in between Jet and Bike gives: Anna =TRANSPOSE(tblResource) Tom Jet Boat Bike Train John =tblPerson[Person] Anna X Tom X John X Jet Boat Bike Train What I want: Anna =TRANSPOSE(tblResource) Tom Jet Boat Bike Train John =tblPerson[Person] Anna X Tom X John X Jet Boat Bike Train Is this possible to achieve using Excel? BR Mats1.1KViews0likes3Comments
Recent Blog Articles
No content to show