Hi,
I am trying to analyze monthly income and volume data; problem is that the data is in following format
<tbody>
</tbody>
When making a pivot table the columns headed Jan 18 / Feb 18 etc are (rightfully) not recognized as dates; would there be an easy way to transform this data so that I could analyze trends based on the dates ? Background information: the excel containts thousands of rows of clients and about 50 columns containing the date datasets (income jan, income feb, income march etc.. ) and is generated in a big corporate without any possibility to change the way the data is delivered to me
thanks !!
I am trying to analyze monthly income and volume data; problem is that the data is in following format
Client Name | Income Jan 18 | Income Feb 18 | Volume Jan 18 | Volume Feb 18 | Visits Jan 18 | Visits Feb 18 | |
Client name 1 | 2343 | 43434 | 4434 | 42234 | 43234 | 23424 | |
Client name 2 | 2342 | 242345 | 25345 | 525 | 453 | 535 |
<tbody>
</tbody>
When making a pivot table the columns headed Jan 18 / Feb 18 etc are (rightfully) not recognized as dates; would there be an easy way to transform this data so that I could analyze trends based on the dates ? Background information: the excel containts thousands of rows of clients and about 50 columns containing the date datasets (income jan, income feb, income march etc.. ) and is generated in a big corporate without any possibility to change the way the data is delivered to me
thanks !!