Multiple rows to multiple columns

I am working on a price list for customers for the past few years. I have computed the ave price/customer/year (Column W in attached input file) besides the ave price per invoice/customer. However, I am not sure how to move the ave price/year/customer to reflect it under the respective year column instead of a separate row for each year.

Attached is the input file for my data as well as the output how I would like it to be.

Any suggestion?

Customer price list (Alteryx).xlsx

Tips and Tricks

Accepted answers

fmvizcaino

Hi @stella1 ,

Attached is an example showing how to accomplish what you need.

Let me know if that works for you.

Best,

Fernando Vizcaino

2020-01-14 Multiple rows to multiple columns.yxmd

All comments

fmvizcaino

Hi @stella1 ,

Attached is an example showing how to accomplish what you need.

Let me know if that works for you.

Best,

Fernando Vizcaino

2020-01-14 Multiple rows to multiple columns.yxmd

stella1

Hi Fernando,

Thanks for your suggestion. That is what I am looking for !

stella1

Hi,

There is something else that I missed out while looking at the solution. Where there is a more than one year customer ave price, how can I reflect it on the same row but under the respective year column instead of separate rows? If you could refer to the input file for customer ABC Ltd & XYZ Ltd.

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703