Cross Tabulation

[Diesel24]

Hi All,

I have a question on what you think would be the best way to solve a problem that I have...

I have attrition numbers for 12 months in columns and City_Tenure in the Rows, it looks something like this....

[TABLE="width: 578"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Code[/TD]
[TD]ATTRITION_Jan_18[/TD]
[TD] ATTRITION_Feb_18[/TD]
[TD] ATTRITION_Mar_18[/TD]
[/TR]
[TR]
[TD]City 1_0-30[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]City 1_31-90[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]City 1_91-180[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]City 1_180-365[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]City 1_366+[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]City 1_All-in[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]City 2_366+[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]City 2_All-in[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]

I am planning on using a list box to select the cities in my data set to show the City and Tenure by Month on an Excel graph. I guess my issue is just grabbing City 1 and plotting that by month alone - would this be done by the Data Validation Function, and would there be a better way to set up the data?

Thank you for your help.

Diesel24

 

[Diesel24]

Anyone any suggestions?