We have a data file (think Excel) that has most of the data setup as columns. These import easily. However, the period (time) dimension is spread as columns (one date per column).
Is there an easy way to import this using the standard Excel import and then convert or collapse all of the date columns into a single "period" dimension?
Appreciate the help.
Take a look at this article that discusses preparing data for Tableau. At the bottom of the article, there is a link to the Excel Add-in that helps you re-shape your data.