Appending more than two Columns using one Dynamic array or spilled formula. Hello, I'm trying to append two or more columns, but i used 3 seperate formulas. Please see attached file. Any help will appreciated
Appending more than two Columns using one Dynamic array or spilled formula. Hello, I'm trying to append two or more columns, but i used 3 seperate formulas. Please see attached file. Any help will appreciated
Last edited by kenesuino; 02-02-2022 at 03:45 AM.
Please try
=IFNA(CHOOSE({1,2,3},A2:A6,D12:D16,C7:C12),"")
Thank you so muchh, it's so usefull! <3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks