I want to achieve the following transformation. I have last_name stored in a repeated record as follows.

In case if you want last names as an array - you already have this array - see below for how to use it

select id, ln as last_name, 
  last_name as concat_last_name,
from your_table, unnest(last_name) ln

with output