How to Combine Two columns into One

[MarkT2551]

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
end

Hi 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. I've attached a small sample of how I would like Column C to look after the combination. Thanks for looking. Sorry, I had to copy the column info into .txt files to upload. I'm using Office 365

[#2]

@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

[#3]

Yes Sir- Perfect!
Thank you very much!

[#4]

@MarkT2551 , you are welcome

[#5]

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.

[#6]

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

[#7]

@MarkT2551 

Yes, "template" is just named range for A1:A5. You may change on any other one in Name Manager.