Column Name Change

[sgaryali]

I want to change the name of B column i.e. - Balance to end M-1 to column G i.e. - January

How can that be done attaching file for reference.

[Nanoq]

Hello Sgaryali
Just to be sure; you need the new name to be whatever is in column G, and value of that column should be whatever is currently in column B?

[sgaryali]

Hi @Nanoq 

Yes, exactly

[Christina_H · Accepted solution]

You can do this with the Dynamic Rename tool.

[Nanoq · Accepted solution]

I think you will have to use a cross tab tool, select all columns as crosstab, EXCEPT [balance to end M-1] and [Month1]
select [Month1] as your new headers and [balance to end M-1] as your values. you can choose sum as the aggregation method