Adding x number of rows based on a fixed criteria
Hi guys,
I came across this challenge I would love to crack with your help. Attached a screenshot.
Each family has N number of kids, these are defined in the separate sheets and should be displayed bellow the family name as additional rows. The identifier is the family name for which we know that a separate sheet exists from where we need to coppy all available rows.
Excel_challenge.PNG
Any idea for an effective solution ?
Thank you
Kirk
If all corresponding families are in tab name ending with " family"
try below code:
HTML Code:
Quang PT
You are really on to something! I tried it out and it works perfectly for specific columns (A+B).
I would need to apply it for the entire rows, as the final dataset I am planning to work with is much larger (A:BN). To illustrate I expanded the example. Would you know how to proceed with the full rows?
Excel_challenge2.PNG
Last edited by Kirkis669; 06-23-2022 at 01:55 AM.
Could you attach a dummy worksheet with full columns/rows?
Here it is :-)
Thanks for checking!
Is it a tough one ? :-)
Could someone pls have a look? Thank you :-)
This proposal employs Get & Transform (AKA Power Query).
The data ranges on each sheet are converted into tables.
The following Advanced Editor code is applied:Note that AFTER the table is placed on the OutputTable sheet it is sorted ascending based on the Family Name column.
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks