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.
      • MarkT2551's avatar
        MarkT2551
        Copper Contributor
        Jun 16, 2023
        NM- I lucked up and found how to edit the cells for the "template" - Thanks Again

Resources