Rearrange table

Hello,

I made the following table. I am trying to see how I can get my first row (month and the total) to be my column headers (1,2,3,4. etc) then members, revenue, volume, miles, cost, unit cost, utilization percentage and PMPM to be my rows. Also If can see how to add color as well make every other column a certain column.

Thank you,

GA_Alteryx_Statement.yxmd

Settings

Output

Transformation

Interface Tools

Accepted answers

binu_acs

@fjmorenojr One way of doing this

GA_Alteryx_Statement.yxmd

All comments

binu_acs

@fjmorenojr can you upload the input file - Statement3.xlsx

fjmorenojr

Should be it I believe

Statement3.xlsx

binu_acs

@fjmorenojr looking for something like below

GA_Alteryx_Statement.yxmd

fjmorenojr

Hello,

Sorry that is not what I was trying to do. I was trying to make the months (1,2,3,4) my column headers. then the column headers my rows, (members, rev, vol... ETC).

If that makes sense.

Thank you

binu_acs

@fjmorenojr If possible can you upload the expected result, that will be easy to understand the requirement

fjmorenojr

Sheet2 is what I am looking for. If possible do you know how to add color ? make the rows different colors. Thank you

GA_Alteryx_Statement.xlsx

binu_acs

@fjmorenojr One way of doing this

GA_Alteryx_Statement.yxmd

binu_acs

@fjmorenojr For coloring the table fields you can set column rules or row rules in the table tool. Column rules you need to select each field and apply the rules,

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703