<div>
This works, but if there's anything neater that'd be great:<br />
<br />
={array_constrain(A:B,coun<wbr />ta({A:A}),<wbr />2),transpo<wbr />se(split(r<wbr />ept(&quot;mysou<wbr />rce,&quot;,coun<wbr />ta({A:A}))<wbr />,&quot;,&quot;))}<br />
<br />
This method requires that column A is fully populated.
</div>


This works, but if there's anything neater that'd be great:

={array_constrain(A:B,counta({A:A}),2),transpose(split(rept("mysource,",counta({A:A})),","))}

This method requires that column A is fully populated.

<div>
Here's another botch that works.. is this as good as it gets?<br />
<br />
=ARRAYFORMULA({A1:B6, &quot;mysource&quot; &amp;&nbsp;LEFT(A1:A6,0) })
</div>


Here's another botch that works.. is this as good as it gets?

=ARRAYFORMULA({A1:B6, "mysource" & LEFT(A1:A6,0) })

<div>
Reason for choosing own solution: it works, and no other solutions were forthcoming.
</div>


Reason for choosing own solution: it works, and no other solutions were forthcoming.

<div>
<div class="content wysiwyg-content">
hi,<br />
This should be easy. In google sheets, I have an array in columns A &amp;&nbsp;B as follows:<br />
<br />
Ref &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Desc<br />
1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;one<br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;two<br />
3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;three<br />
4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;four<br />
5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;five<br />
<br />
Example: <a href="https://docs.google.com/spreadsheets/d/1OVwUpodKWxgEsUuLr4wW1K_srW90ZjgvvMoZwmt1fdQ" rel="ugc">https://docs.google.com/spreadsheets/d/1OVwUpodKWxgEsUuLr4wW1K_srW90ZjgvvMoZwmt1fdQ</a><br />
<br />
I can copy this array by using formula ={A:B}<br />
<br />
How can I append a constant value, eg 'mysource' so that the output is:<br />
<br />
Ref &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Desc &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mysource<br />
1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;one &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mysource<br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;two &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mysource<br />
3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;three &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mysource<br />
4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;four &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mysource<br />
5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;five &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;mysource<br />
<br />
Thanks
</div>
</div>


hi,
This should be easy. In google sheets, I have an array in columns A & B as follows:

Ref	Desc
1	one
2	two
3	three
4	four
5	five

Example: https://docs.google.com/spreadsheets/d/1OVwUpodKWxgEsUuLr4wW1K_srW90ZjgvvMoZwmt1fdQ

I can copy this array by using formula ={A:B}

How can I append a constant value, eg 'mysource' so that the output is:

Ref	Desc	mysource
1	one	mysource
2	two	mysource
3	three	mysource
4	four	mysource
5	five	mysource

Thanks

Appending a constant to an array in google sheets

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.

Google Workspace

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.