Stack columns but keep first 5

[teddzoon]

Hi,

I've been looking around to try and figure out how to most efficient stack columns.

My data (which is updated daily, hence have different amount of rows each day) currently have an output like this:

Company	Name	Code1	Name	Code2	Name	Year	Starting Value	Total Value	October	November	December	January	Feb	March
1	XX	99	YY	123	Sales	2018	0	500	80	85	75	40	100	120
2	XY	99	YY	123	Sales	2018	0	400	40	40	20	20	120	160

<tbody>
</tbody>

I would like to stack the months, so my output would look something like this:

Company	Name	Code1	Name	Code2	Name	Year	Starting Value	Total Value	Month	Amount
1	XX	99	YY	123	Sales	2018	0	500	October	80
1	XX	99	YY	123	Sales	2018	0	500	November	85
1	XX	99	YY	123	Sales	2018	0	500	December	75
etc

<tbody>
</tbody>

I tried recording a macro, but it did not handle different number of rows correctly.
So when I used the output on fewer rows, it still pasted values on fixed cells, instead of using "next empty cell available".

Have you got any magic tricks for me?

Kind Regards
Ted

 

[JackDanIce]

Welcome to the board. A pivot table can do this for you, removing need for macros.

Lots of online guides and tutorials on pivot tables for you to read up on.

 

[teddzoon]

Hi JackDanIce,

Then it might be something I'm missing completely. I've googled around quite a bit and not really found anything.
If I put the data in Pivot, and drag my columns to rows instead, I still dont get the desired outcome. The columns still put themselves in columns.

See this:
https://imgur.com/a/AQxORX1

It still does not stack the columns into a single coloumn.
What am I missing?

Company	Name	Code1	Name	Code2	Name	Year	Starting Value	Total Value	Month	Value
1	XX	99	YY	123	Sales	2018	0	500	October	80
1	XX	99	YY	123	Sales	2018	0	500	November	85
...
2	XY	99	YY	123	Sales	2018	0	400	March	160

<tbody>
</tbody>

Cheers,
Ted