Rearrange table

[fjmorenojr]

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,

[binuacs]

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

[fjmorenojr]

Should be it I believe

[binuacs]

@fjmorenojr looking for something like below

[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

[binuacs]

@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

[binuacs · Accepted solution]

@fjmorenojr One way of doing this

[binuacs]

@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,