Group the month yearwise in columns

**BIKRANT.RANJITKAR** · 08-24-2020, 05:44 AM

Dear All,

I wanted to group the month yearwise in columns without pivoting it how can i do that?

example.png

I want this to be group by yearwise..

**alansidman** · 08-24-2020, 06:18 AM

Please read the yellow banner at the top of this page on how to attach a file.

**alansidman** · 08-24-2020, 06:22 AM

Is this what you are looking to do?

Excel 2016 (Windows) 32 bit

	A	B	C
1	Column1	Column2	Column3
2	2020	Jan	100
3	2020	Feb	100
4	2020	Mar	100
5	2020	Apr	100
6	2020	May	100
7	2020	Jun	100
8	2020	Jul	100
9	2020	Aug	100
10	2020	Sep	100
11	2020	Oct	100
12	2020	Nov	100
13	2020	Dec	100
14	2021	Jan	100
15	2021	Feb	100
16	2021	Mar	100
17	2021	Apr	100
18	2021	May	100
19	2021	Jun	100
20	2021	Jul	100
21	2021	Aug	100
22	2021	Sep	100
23	2021	Oct	100
24	2021	Nov	100
25	2021	Dec	100

Sheet: Sheet2

**BIKRANT.RANJITKAR** · 09-06-2020, 09:21 AM

Actually I want to create Prepaid amortization management excel file. In which the amount is segregated monthly calculation on daily basis.

**maniacb** · 09-06-2020, 10:54 AM

You can copy the cells and past special -> transpose? Is that what you need?

**alansidman** · 09-06-2020, 04:30 PM

If what I presented is not what you are looking for, please upload a mocked a solution so that we understand exactly what you need.

**Rick Rothstein** · 09-06-2020, 06:02 PM

Originally Posted by BIKRANT.RANJITKAR

I wanted to group the month yearwise in columns without pivoting it how can i do that?
I want this to be group by yearwise..

Please Note
-------------------
One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data). To sum up... we only know what you tell us, nothing more. Also, uploading an actual file (see yellow banner near the top of this forum's window) showing your data as it exists and on another sheet showing how you want it to look after being processed would help immensely.

**BIKRANT.RANJITKAR** · 09-08-2020, 01:56 AM

I did upload an excel file as per instruction.. but it didnot shows up... what is happening? I dont know

**jindon** · 09-08-2020, 02:06 AM

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**BIKRANT.RANJITKAR** · 09-09-2020, 01:56 AM

In the attached excel file, I want to create measure and affix to the pivot table column. The requirement of the column is "Amount-Grand Total" and shows as example in excel Sheet Name: Prepaid Amortization Schedule.

Sorry for the earlier mistakes.

I hope this time I did correctly.