I need to pull data from a data file which will have changing column names.
|Name||Dept||Job||Jan 2018||Feb 2018||Mar 2018||Apr 2018||May 2018||Jun 2018|
The first few column names will remain the same, but the Month-Year columns would keep changing because this is a rolling 12 or 15 month file.
What I am trying to achieve is to have a dynamic logic so I can pull all fields (with field names) and also derive month year values from the column headers, to later use them in the calendar & dates.
NOTE - CROSSTABLE might not be the answer, because the user wants to see a separate column for each month.
Any help is appreciated. Thanks