Skip to main content
Nintex Community Menu Bar

How do we merge similar fields in Excel in Nintex docgen

As in below screen shot we have merged the “Stage” Column.

 

 Stage Name Count Open Signal Amount Status
A ABC Pipeline 23 TRUE Red 45 Closed
DFC Pipeline 45 FALSE Blue 43 New
New Pipeline 67 FALSE Green 34 Ongoing
CDF Pipeline 34 FALSE Yellow 23 Blocked
             
B ABC Pipeline1 23 TRUE Red 45 Closed
DFC Pipeline2 45 FALSE Blue 43 New
New Pipeline3 67 FALSE Green 34 Ongoing
CDF Pipeline4 34 FALSE Yellow 23 Blocked
New Pipeline5 67 FALSE Green 34 Ongoing
             
C ABC Pipeline11 23 TRUE Red 45 Closed
DFC Pipeline21 45 FALSE Blue 43 New
New Pipeline111 67 FALSE Green 34 Ongoing
CDF Pipeline41 34 FALSE Yellow 23 Blocked
New Pipeline654 67 FALSE Green 34 Ongoing
New Pipeline551 67 FALSE Green 34 Ongoing

Hi ​@dinesh  - when replicating we will always have a row for that item. You may have to have logic and a formula to have the cell pre merged for a set number  and then use a formula to get the correct group name. 

 

Additionally you can replicate in to different sheets and then use Excel logic to get it all formatted on another output sheet.

Hi Brant when data is populating in grouping , it will be dynamic data, so we cannot pre merge for a set and we cannot decide in advance how may records will fall in this section.

So in my opinion this approach will not work.

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings