Problem solved with

$1 = remote(A,@@#$1)

as described on the manual page https://orgmode.org/manual/References.html#Field-coordinates-in-formulas-1 <https://orgmode.org/manual/References.html#Field-coordinates-in-formulas-1>

Where is the coordinate @@# documented?


> On 11 Mar 2024, at 18:52, Wu Ming <wu.ming2@icloud.com> wrote:
> 
> Hello,
> 
> #+NAME: A
> Table with header row here
> 
> #+NAME: B
> Table with header row here
> #+TBLFML: $1 = remote(A,$1)
> 
> Does nothing. 
> 
> $1 = remote(A,@0) referring current row w implicit column does not work. Debug shows on row 2 of current table it returns the value of row 1, the header, on table A. 
> 
> Same result as above with @0$1 instead. 
> 
> $1 = remote(A,@2$1) does what expected. For every row copies the same value of @2$1 from table A to table B. 
> 
> Need to refer multiple columns on different tables in a column formula for a final table. 
> 
> Please advise. Thanks. 
> 
>