Forum Discussion
Merging cells in a table
Hello, Thank you for support, appretiate it. I tried matrix, and could not get the result the same I wanted. But I improvised , I mannaged it this way below. headers are in red circle and years are dynamic , the rest is text boxes. it met expectations.
Hi Anonymous
Please try this:
Here I create a set of sample:
Table:
Then add a matrix:
Click the Expend all down one level in the hierachy until the last level:
Then add a Slicer, so that the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, Thank you for support, appretiate it. I tried matrix, and could not get the result the same I wanted. But I improvised , I mannaged it this way below. headers are in red circle and years are dynamic , the rest is text boxes. it met expectations.