how to rename the dynamically generated month fields

[lostcauz3]

I have a table with the following data

08	09	10
data	data	data
data	data	data
data	data	data

i want to rename the 08,09,10 to Aug21,Sep21 and Oct21

the field name can be anything from 01 to 12 

01 = Jan21 , 02 = Feb 21, 03 = March21 etc 

How can i rename them in this case.

[ITWhisperer · Accepted solution]

| transpose 0
| eval column=strftime(strptime("01-".column."-21","%d-%m-%y"),"%b%y")
| transpose 0 header_field=column
| fields - column

[lostcauz3]

Thank you!

You've helped me a lot.