Combining multiple quantity by year columns

[kspanier]

I am newbie to PBI and have viewed multiple threads, vids and urls for my issue, but I cannot find a way to solve it. I'm sure it is pretty simple, but I have spent the last two days trying to resolve...please can anyone help? Thanks in advance.

I have multiple qty columns for 4 different years and need to combine them (into new rows for each I think), so that I can then divide by 12 to get the monthly quotas:

I have tried merge, append, unpivot, and it doesn't seem to give me what I think I need.  I need one combined Qty column with all values together that I can then work with to use with the MonthNo column values. 

[ryan_mayu · Accepted solution]

have you tried  select the first three columns and unpivot other columns?

if this does not work, pls provide some sample data(not the screenshot) and the expected output.

you can just paste the sample data in the reply

[kspanier]

Thank you so much for the quick reply Ryan, appreciated.  I just tried that and it is what I needed to do - wow - many thanks! The answer was in front of me the whole time and I was just not seeing it. 😳 🙄

[ryan_mayu]

you are welcome