Query to make rows of data in columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a query to pull transactional data by month stored
in rows and create a result that shows the transactional data in columns?
Currently, the the numbers are stored in the same column but can be
differentiated by another column that contains the date of the number. In
the end, all of January's data would be in one column. February would be in
another. All of the way until to the end of the year. Thank you!
 
Hi Dorian - thank you very much for your help. I was trying to do too much
in one query. I had to first do a crosstab query and then create a custom
query to match that result with another table. I was able to obtain my
results. Thank you so much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Calculate difference in rows in a query 1
query result in relation with table 4
Query that picks different column from a table based on the inp va 3
VBA - retrieve data on last create named range from previous inserted named range 0
Excel Help to copy information from one row at a time to another sheet 1
Query out transaction 1
Need help in Monthly Query Showing Months Name in Columns 6

Back
Top