Reporting

sarithaligonfin

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 

Merging cells for the output.yxmd

atcodedog05

Hi @sarithaligonfin 

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 : )

merge cells.yxmd