Problem solved. Thanks from the heart!

Awesome 👍 I appreciate

@ExcelCampus

Ай бұрын

Thank you! Cheers! 😀

Add this within a let function and it's perfect.

Awesome ❤

GENIUS!!! SO THANKS!! 😭😢😭😭😭😭

@ExcelCampus

4 ай бұрын

Welcome! 😀

like👍232 wow! VStack ( I will check the video you uploaded earlier?) I didn't know if we can have FILTER as formula! that's great!

@ExcelCampus

11 ай бұрын

Thank you!, @JessicaJang77 ! 😀

Thank u jon. It would be interesting to show how we used to do this befire VStack comes out

@ExcelCampus

11 ай бұрын

Good question! There are a lot of ways to stack data. One other great option is the Append feature of Power Query. Here is a video that explains more about that process. kzread.info/dash/bejne/epearbGuo7KwmKQ.html VBA is another solution. Here is a video on automating the copy/paste process with VBA. kzread.info/dash/bejne/a4ZkwcqYkdK5cag.html I hope that helps. Thanks again and have a nice weekend! 🙂

@nadermounir8228

11 ай бұрын

@ExcelCampus I have been using index function along with area number. To get the row number I use the Mod function and for the area number I use the int function (number incrementor). Then I wrap the formula in the filter function to remove the zeros. The rows though have to be the same.

Thank you so much. One question. Is there a way to automatically sort the vstack-ed data chronologically. For example each table in the division sheets have date column. The first line of division 1 is 1january, the second line of division 1 is 1march. The first line of division2 is 1feb.

@ExcelCampus

3 ай бұрын

Hi Martin! 😊 Yes, the vstack data can be sorted using the SORT function. As the VSTACK was wrapped with FILTER in the video, wrap the FILTER with SORT. 🙂