Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have 4 columns of data, with each row showing one set of data. Then another 4 columns of the same type of data, but for the next month, then another 4 for the following month, etc. It is organized like this so it can be pulled into another sheet. However, I want to analyze this data for the whole year, with pivot tables (also charts, etc), but if I make a pivot table of this data, it makes the columns with the same title another group (month, month2, month3...). I am come the data from each month onto another sheet, so that it is all in just 4 columns. Could you help with this
Solved by O. D. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 17/08/2018 - 12:35
Excelchat Expert 17/08/2018 - 12:35
User 17/08/2018 - 12:36
Did you get my problem statement?
Excelchat Expert 17/08/2018 - 12:37
i can see your building the sheet 1 can you explain with example
Excelchat Expert 17/08/2018 - 12:38
is each of the Date Month Amount Description repeating for each month?
User 17/08/2018 - 12:38
Excelchat Expert 17/08/2018 - 12:39
in jane why is the date 8/12/2018
Excelchat Expert 17/08/2018 - 12:41
ok now you want to compare jan amount and description with feb amount and desc and so on
User 17/08/2018 - 12:41
So I would like in sheet 2, the data for each month in sheet 1 in a single list
Excelchat Expert 17/08/2018 - 12:41
meaning 1 below other?
User 17/08/2018 - 12:41
Excelchat Expert 17/08/2018 - 12:41
1 min
User 17/08/2018 - 12:42
So if this were the full set of data, sheet2 would read the first row for jan, put it in row 2 of sheet2, put row 3 in row 3 of sheet2, then when it gets to the end of january, put the first entry for february in row 4 of sheet 2
User 17/08/2018 - 12:43
Then it would go through february, and when there are no more entries for february, march, and so one
User 17/08/2018 - 12:43
So that Sheet2 is one continuous list with all of the entries for each month
Excelchat Expert 17/08/2018 - 12:44
ok give me a min
User 17/08/2018 - 12:44
Also, I am using Excel, if that makes a difference
User 17/08/2018 - 12:44
Not google sheets
User 17/08/2018 - 12:44
Thank you
Excelchat Expert 17/08/2018 - 12:44
Excelchat Expert 17/08/2018 - 12:49
working on the formula
User 17/08/2018 - 12:50
Thank you
Excelchat Expert 17/08/2018 - 01:04
Can i add new columns and a row above ?
User 17/08/2018 - 01:04
User 17/08/2018 - 01:11
Were you able to make the formula?
Excelchat Expert 17/08/2018 - 01:12
yes building on it its quite complex as we have to move between columns and rows
Excelchat Expert 17/08/2018 - 01:12
you will get an extention prompt
User 17/08/2018 - 01:12
User 17/08/2018 - 01:13
That is what I was having trouble with as well, how to move over columns and up rows before starting over
Excelchat Expert 17/08/2018 - 01:31
check the formula
[Uploaded an Excel file]
Excelchat Expert 17/08/2018 - 01:32
[Uploaded an Excel file]
Excelchat Expert 17/08/2018 - 01:33
I have added a new column Named Row which si just a uniques number for that month
Excelchat Expert 17/08/2018 - 01:34
I'm checking for a given month if the row is non blank then getting it else going to the next month :)
Excelchat Expert 17/08/2018 - 01:34
you there
User 17/08/2018 - 01:35

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc