Please see my sample data attached. I am looking for a formula that would take multiple lists of Stores and their Values, and combine them all into one continuous list.
Please see my sample data attached. I am looking for a formula that would take multiple lists of Stores and their Values, and combine them all into one continuous list.
Last edited by Denise0618; 10-06-2021 at 11:51 AM. Reason: Solved
I assume that the Store List are NOT (always) the same length (number of rows) ?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
How aboutFormula:Please Login or Register to view this content.
That's correct, they will almost always be different lengths.
This one worked!! Thank you!!!
In that case you can useThat's correct, they will almost always be different lengths.which will get rid of the blank rows.Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks