Skip to main content
Nintex Community Menu Bar
Question

How do we merge similar fields in Excel


Forum|alt.badge.img+1

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
Translate
Did this topic help you find an answer to your question?

2 replies

Brent_Doc
Nintex Employee
Forum|alt.badge.img+12
  • Nintex Employee
  • 53 replies
  • January 10, 2025

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.

Translate

Forum|alt.badge.img+1
  • Author
  • Rookie
  • 2 replies
  • January 14, 2025

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.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings