Hi there,
Is there any way I can merge cells in a table the way it is shown in the expected output below?
My input:
Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 |
Store 1 | Capital | 1 | 2 | 3 | 4 | 5 |
Store 1 | Operating | 5 | 10 | 15 | 20 | 25 |
Store 2 | Capital | 1 | 2 | 3 | 4 | 5 |
Store 2 | Operating | 5 | 10 | 15 | 20 | 25 |
Store 3 | Capital | 1 | 2 | 3 | 4 | 5 |
Store 3 | Operating | 5 | 10 | 15 | 20 | 25 |
Store 4 | Capital | 1 | 2 | 3 | 4 | 5 |
Store 4 | Operating | 5 | 10 | 15 | 20 | 25 |
My expected output:
Thanks,
Saritha
Solved! Go to Solution.
Here is how you can do it.
Workflow:
Output:
Please go through the workflow and let me know if you have any questions 🙂.
Hope this helps : )
Thanks heaps!
Is there any tips on how to align the cotents of the field 1 in the middle?
You can set a row rule that would be the efficient way to center align all columns. If its only for specific column you can alignment for a specific column in table tool.
Hope this helps : )
Happy to help : ) @sarithaligonfin
Cheers and have a nice day!
Sorry, I didn't word that question properly.
I meant align the contents "middle - left aligned"
Thanks