<div>
This seems to be an Excel question, so not sure why you selected the Access topic? &nbsp;I won't go into too much detail just in case I am misunderstanding.<br />
<br />
Looking at the Excel sheet you provided, Excel has the capability called Pivot Tables to do what you want. &nbsp;But to do that you need to get your data in an easier format for the tool to work with. &nbsp;So I first created a new sheet, &quot;flattening&quot; your sample data into a more database design, looking like:<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1203007/sshot-345.png" target="_blank" title="sshot-345.png (26 KB)"><img alt="sshot-345.png" class="file-block lazyload" style="max-width: 324px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w44/1203007/sshot-345.png" /></a>Then, I selected that and inserted a new pivot table on the next sheet, selecting the row, column and data fields:<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1203006/sshot-344.png" target="_blank" title="sshot-344.png (23 KB)"><img alt="sshot-344.png" class="file-block lazyload" style="max-width: 761px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w44/1203006/sshot-344.png" /></a>Attaching my test sample, let me know if this is what you want to do, or if I missed the question.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1203008/EE29066341.xlsx" target="_blank" class="file-inline" title="EE29066341.xlsx (18 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>EE29066341.xlsx</a><br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


sshot-344.png

EE29066341.xlsx

sshot-345.png

<div>
This is an Access question. &nbsp;I cannot alter the Excel file which really is an Access table. &nbsp;I only put it together in Excel to show what the table looks like.
</div>


<div>
Did you try the crosstab wizard? &nbsp;Since you are having a problem with Access, it would be better to post pictures of the &quot;Access&quot; problem.<br />
<br />
If your question is - how do I get the 12 month names in month order? &nbsp;Then the answer is, use the Column headings property. &nbsp; But a word of warning. &nbsp;When you use column headings you never get any data that doesn't match one of the headings. &nbsp;This isn't a problem with months because there's only 12 of them and they don't change but if you wanted department headings for example and you wanted them in some order other than alphabetical so you decided to use the column headings property, &nbsp;if the data contained a department that wasn't defined in the column headings list, the data for that department would not be included in the report.<br />
<br />
One more caveat. &nbsp;Make sure your select query includes a selection by year otherwise you mush data for all years into each month's column.
</div>


<div>
Attached: &nbsp;Sample Access file/table.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1203069/PricingExample.accdb" target="_blank" class="file-inline" title="Pricing Example (396 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>PricingExample.accdb</a>
</div>


PricingExample.accdb

<div>
Not true. &nbsp;I did and what I tried did not work. &nbsp;I don't understand cross-tab queries.
</div>


<div>
What happened when you ran the wizard?
</div>


<div>
See attached. &nbsp;Not even close.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204110/PricingExample2.accdb" target="_blank" class="file-inline" title="Pricing Example 2 (416 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>PricingExample2.accdb</a>
</div>


PricingExample2.accdb

<div>
Then this goes back to the old concept of &quot;Normalization&quot;<br />
Your raw data is not in the correct format to give you what you are looking for (easily).<br />
<br />
If your data were in the more appropriate format, like this:<br />
<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MONTH_DATE &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRICE &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PriceType<br />
1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$52.50 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$53.47 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$49.33 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$51.06 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$48.48 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$45.18 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$46.63 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$48.04 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$49.82 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ABC<br />
10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$3.30 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$2.85 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
12 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$2.88 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
13 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$3.10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$3.15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$2.98 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$2.98 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$2.09 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
18 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9/1/2017 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$2.98 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XYZ<br />
<br />
...Then your crosstab would simply be this:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42356938-1"><span>TRANSFORM First(AC_PRICE2.PRICE) AS FirstOfPRICE</span>
<span>SELECT AC_PRICE2.PriceType, First(AC_PRICE2.PRICE) AS [TotalOf PRICE]</span>
<span>FROM AC_PRICE2</span>
<span>GROUP BY AC_PRICE2.PriceType</span>
<span>PIVOT Format([MONTH_DATE],&quot;mmm&quot;) In (&quot;Jan&quot;,&quot;Feb&quot;,&quot;Mar&quot;,&quot;Apr&quot;,&quot;May&quot;,&quot;Jun&quot;,&quot;Jul&quot;,&quot;Aug&quot;,&quot;Sep&quot;,&quot;Oct&quot;,&quot;Nov&quot;,&quot;Dec&quot;);</span>
</code></pre>
<br />
...and it would look like this:<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w45/1204471/Report2.png" target="_blank" title="Normalized Crosstab (10 KB)"><img alt="Normalized Crosstab" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w45/800_1204471/Report2.png" /></a>...easy peasy lemon squeezy<br />
;-)<br />
<br />
As with all un-normalized data, ...if left in the <b>in</b>correct format, ...you will always have to jump though endless hoops to get the data to do things that are ridiculously simple, ...<b>if </b>the data were in the correct format.<br />
<br />
For example, if the data is left un-normailzed you would have to make a report in design view:<br />
...and create all the textboxes and lables that your layout example requires.<br />
...then set <b>all </b>the Monthly textboxes to have a controlsource of something like this:<br />
(for example: ABC_Price for January 1st 2017):<br />
=DLookUp(&quot;ABC_PRICE&quot;,&quot;AC_P<wbr />rice&quot;,&quot;MON<wbr />TH_DATE= #1/1/2017#&quot;)<br />
(again, ...changing the Field and the Date arguments for *every single textbox*)<br />
Then you get something like what you are after:<br />
&nbsp; &nbsp; &quot;that will give me the data for a REPORT&quot;<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w45/1204467/Report1.png" target="_blank" title="Un-normailzed Report (4 KB)"><img alt="Un-normailzed Report" class="file-block lazyload" style="max-width: 475px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w45/1204467/Report1.png" /></a><br />
;-)<br />
<br />
JeffCoachman
</div>


Report2.png

Report1.png

Report3.png

<div>
Didn't I post a database that fixed this problem for you? &nbsp;Perhaps it was in a different thread.
</div>


EE29066341.accdb

<div>
Steve,<br />
As you can see, (from all of our posts), the lynch-pin here is that your data is not normalized.<br />
<br />
If the other tables in this system were designed by the same DBA, ...you will have to always be going through crazy machinations to do things that are normally simple, if the data was properly structured.<br />
<br />
JeffCoachman
</div>


<div>
My comment <a href="https://www.experts-exchange.com/questions/29066341/Trying-to-figure-out-how-to-create-a-crosstab-query-using-Excel-file.html?anchorAnswerId=42357851#a42357851" rel="ugc"><b>here</b></a> produced exactly what you were looking for, how was that not considered?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w45/1209647/sshot-349.png" target="_blank" title="sshot-349.png (28 KB)"><img alt="sshot-349.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w45/800_1209647/sshot-349.png" /></a><br />

<hr />
»<b><i>bp</i></b>
</div>


sshot-349.png

<div>
Pat had posted the solution 3 days ago. &nbsp;I had missed it.
</div>


<div>
<blockquote>
<i>Pat had posted the solution 3 days ago. &nbsp;I had missed it.</i>
</blockquote>
<br />
What comment is that in this thread, I don't see it?<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


<div>
I am terribly mixed up and confused, &nbsp;I have asked the moderator to re-open the topic so I can re-assign points.
</div>


<div>
There may be more than one thread on this topic.
</div>


<div>
You all either posted a solution or offered very good insight. &nbsp;Thank you.
</div>


<div>
<div class="content wysiwyg-content">
Please see the attached Excel file. &nbsp;I'm trying to figure out how to create a crosstab query that will give me the data for a report that looks like this:<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1203001/Report-Example.bmp" target="_blank" title="Report Example (219 KB)"><img alt="Report Example" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w44/800_1203001/Report-Example.bmp" /></a><a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1202995/Pricing-Example-File.xlsx" target="_blank" class="file-inline" title="Pricing Example File (8 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Pricing-Example-File.xlsx</a>
</div>
</div>


Report-Example.bmp

Pricing-Example-File.xlsx

Please see the attached Excel file.  I'm trying to figure out how to create a crosstab query that will give me the data for a report that looks like this:




Trying to figure out how to create a crosstab query using Excel file

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.