turn a row into a column

[LETICIAHELENA]

hello how are you?

How Can I change row into a column?

My date need to be a column and the dates have to be the same

Thanks 

[binu_acs]

@LETICIAHELENA What is the expected output? 

[Clifford_Coon]

Hi @LETICIAHELENA ,

Making some assumptions:

1. The date value is in row 1, column F2

2. Carry this value as is to all rows.

You can do this with a multi row formula:

 

[Qiu]

@LETICIAHELENA 
Maybe you are looking the Dynamic Rename option?