VSTACK two tables into one
. i am creating a cleaing schedule spreasdsheet. I have table 1 "Daily Chores" B5:D29,table 2"Weekly Chores" F5:H29 and.table 3 "Summary of Chores" . Each table has three columns. I've been using VSTACK and IF functions in the formula.
Formula:
=VTACK(IF(B5:D29<>"",B5:D29,""),IF(F5:H29<>"",F5:H29,""))
I end up with many bank rows between. As I'd like to be able to add data to either table as needed.
Welcome to the forum.
Just do a simple VSTACK without the IFs, then filter the resulting array:
=LET(v,VSTACK(B5:D29,F5:H29),FILTER(v,INDEX(v,,1)<>""))
Last edited by AliGW; 11-28-2023 at 01:56 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
No, that will nlot work. As I want Table 1 and 2 to be stacked in table 3.
Sorry - what do you mean? You cannot use spill arrays inside a structured table, if that’s what you mean.
A ‘thank you’ might have been nice.
You DID NOT SOLVE MY PROBLEM. SO NO, I WILL NOT SAY TYHAHNK YOU! YOU IDIOT
Do you say thnank you when someone isn't helpful?
I was trying to be helpful and gave you a solution - did you actually try it? I would thank anyone for trying to assist, yes.
Outbursts like this will not be tolerated: mind your manners and be polite if you wish to remain a member here.
Stop thinking you know what my spreadsheet looks like. AAUUGGHH! Since you want a thank you for not solving my issue, thank you for making me agravated.
I used an expert just yesterday to vstack, filter and if functions to put daily chores and weekly chores for onlyb on specific days. It will work I need the right formula
Assuming stuff only makes an *** of yourself
Utterly unacceptable behaviour - thread closed and user banned.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks