I need to repeat labels for rows while merging repeating data into excel. For example, I have the following template: enter image description here

After merging I need it to look like: enter image description here

Using the template above it looks like: enter image description here

Could someone help, please?


Given the way that Repeating Dynamic Formulas work in Excel Templates in Conga, and assuming that the first row of Label 1/Value 1.1 is not all the way on top of the Excel spreadsheet, you can maybe try something like this:

&=&=IF(A{-1}="Label 1", "Label 2", IF(A{-1}="Label 2", "", IF(A{-1}="", "Label 1", "")))

(replace the column A with whichever column you want labels to be displayed in)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.