Excel tables are limited not to merge data vertically across rows. But there could be rare use cases where it is required to do vertical merge. It is possible to create a merge like solution using Conditional Formatting which is explained in this solution.
Please support us by watching the video, like the content and subscribe to our channel