How to change all column values to its header ?

[Quick]

I receive an database excel sheet with only one cell. It's a database date of my second sheet.

I could use the UNION to group the databases but my date is on the header.

How can I change all fields on this column to the header value?

[sparksun]

Multi-field Formula can easily do it:

[geraldo]

@Quick 

to import excel