automatic transpose of rows to columns with reference to rows

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

thank you! you have no idea how much my life is simpler now!