TRANSPOSE DATES HEADER ONLY AND IDENTIFY AGEING

[PassION_es]

Hi, Requesting assistance to transpose based on date format in the field, assuming we have a lot of input files combines into one with lots of dates columns. We want to generate an output summary where dates are converted to the following:

0 to 6 mos.

6 mos. To 1 year

over 1 yr but not over 2 yrs

over 2 yrs but not over 3 yrs

and so on and so forth

[Mathias_Nielsen]

Hi, see if this helps.

You can add the more filter for whatever period you would like :)