Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date table with no date column

Hi,    I have a data where i have just Period column with short month (Jan, Feb, Mar, Apr.......,Dec). Rest all the column in numbers with yearly sales numbers.  I want to convert the Period colum...
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Can you clarify further?  I thought that is what was provided.  Can you show what the output table should look like?  Your data should be unpivoted for easiest analysis/visualization, and you will need a year component to convert the Period column to a date.

    Pat