**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

Hi

Excelchat Expert
17/08/2018 - 12:35

hi

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

yes

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

Yes

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

ok

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

Sure

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

Okay

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

Yes

**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.*