How to Combine Two columns into One

Question

Column A

begin ConfiguredSIPBinding ConfiguredSIPBinding.	
  FaultMonitoringProfile                     FaultMonitoringProfile.1	
  ApplyFMPToRelatedObjectTypes                    {Subscriber	SIP Trunk}
  AllowFMPsFromRelatedObjectsToApply              False	
end

Column B

536870918
536871099
536871171
5003
xxx

Column C

begin ConfiguredSIPBinding ConfiguredSIPBinding.536870918
  FaultMonitoringProfile                     FaultMonitoringProfile.1
  ApplyFMPToRelatedObjectTypes                    {Subscriber,SIP Trunk}
  AllowFMPsFromRelatedObjectsToApply              False
end
begin ConfiguredSIPBinding ConfiguredSIPBinding.536871099
  FaultMonitoringProfile                     FaultMonitoringProfile.1
  ApplyFMPToRelatedObjectTypes                    {Subscriber,SIP Trunk}
  AllowFMPsFromRelatedObjectsToApply              False
end
begin ConfiguredSIPBinding ConfiguredSIPBinding.536871171
  FaultMonitoringProfile                     FaultMonitoringProfile.1
  ApplyFMPToRelatedObjectTypes                    {Subscriber,SIP Trunk}
  AllowFMPsFromRelatedObjectsToApply              False
end
begin ConfiguredSIPBinding ConfiguredSIPBinding.5003
  FaultMonitoringProfile                     FaultMonitoringProfile.1
  ApplyFMPToRelatedObjectTypes                    {Subscriber,SIP Trunk}
  AllowFMPsFromRelatedObjectsToApply              False
end
begin ConfiguredSIPBinding ConfiguredSIPBinding.xxx
  FaultMonitoringProfile                     FaultMonitoringProfile.1
  ApplyFMPToRelatedObjectTypes                    {Subscriber,SIP Trunk}
  AllowFMPsFromRelatedObjectsToApply              False
endHi All,I have a workbook with two columns of information. I would like to combine column A with column B into a new column for example column C. Column A information will always stay the same, but I will occasionally copy and paste new values into column B. I don't care if I need tables, multiple sheets or whatever to make this work. I will always want column A combined with column B until there are no more entries in column B (if that makes sense) because the number of entries in Column B will definitely change.&nbsp;I've attached a small sample of how I would like Column C to look after the combination. Thanks for looking.&nbsp;Sorry, I had to copy the column info into .txt files to upload. I'm using Office 365

sergeibaklan · Answer

MarkT2551&nbsp;
Perhaps like
=LET(
    updateBlock, LAMBDA(template,value,
            VSTACK(
                TRIM(TAKE(template, 1)) &amp; 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 · Answer

Yes Sir- Perfect!Thank you very much!

sergeibaklan · Answer

MarkT2551&nbsp;, you are welcome

markt2551 · Answer

Last question on this- If I need to change the data in column A to this...begin ConfiguredSIPBinding ConfiguredSIPBinding.FaultMonitoringProfile NoneendHow 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 · Answer

NM- I lucked up and found how to edit the cells for the "template" - Thanks Again

Forum Discussion

How to Combine Two columns into One

6 Replies

Resources