example.xlsx

Hi
I am looking for some sort of automatic copy-paste option, that knows to transpose a row into a column, but keeps pointing/referring to the original data of the row.

In the file above I created an example of my question:
I have some data in row 1
I would like this data to be copied into column g, so that every time I change the data in row 1, the data will automatically change in column g as well.
If I use the "copy-paste with transpose" option, only the values are updated, so that's not good enough, because when the values in the row change, they don't change in the column.

thanks