Forum Discussion

MarkT2551's avatar
MarkT2551
Copper Contributor
Jun 16, 2023

How to Combine Two columns into One

Column A begin ConfiguredSIPBinding ConfiguredSIPBinding. FaultMonitoringProfile FaultMonitoringProfile.1 ApplyFMPToRelatedObjectTypes {Subscriber SIP T...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 16, 2023

MarkT2551 

Perhaps like

=LET(
    updateBlock, LAMBDA(template,value,
            VSTACK(
                TRIM(TAKE(template, 1)) & value,
                DROP(template, 1)
            )
        ),
    REDUCE(
        updateBlock(template, B1),
        $B$2:INDEX(B:B, COUNTA(B:B) ),
        LAMBDA(a,v, VSTACK(a, updateBlock(template, v)))
    )
)

to

  • MarkT2551's avatar
    MarkT2551
    Copper Contributor
    Jun 16, 2023
    Yes Sir- Perfect!
    Thank you very much!
      • MarkT2551's avatar
        MarkT2551
        Copper Contributor
        Jun 16, 2023
        Last question on this- If I need to change the data in column A to this...
        begin ConfiguredSIPBinding ConfiguredSIPBinding.
        FaultMonitoringProfile None
        end

        How would the formula look with the new information? I tried looking at what defined column A in your first response. It looks like it's part of a =template but I couldn't figure out how to edit the template or I was heading down the wrong path.

Resources