Dynamic header renaming

[ayadav8]

Hey community,

I am stuck with a problem of dynamic renaming of a column which depends on the value from another column.

I want the header 'Value' to be changed by the month name in string from first row  of 'Month' column. I need the header name to be changed dynamically as the dates in 'month' column changes every time.

Attached screenshot will give you a clear picture. Any help is appreciated. Thanks!

[gnans19 · Accepted solution]

Hi @ayadav8

Attached the solution

[danrh · Accepted solution]

Another option :)

[ayadav8]

@gnans19 works perfectly fine. Thank you so much

[ayadav8]

@danrh thanks for the crisp and precise solution.