I think I need a macro to do this.

[shapenote1]

I have spreadsheet which has a cost center listed going down vertical and for each cost center this is potentially 35+ project numbers which has budget info that run horizontally on the spreadsheet.

Is there a formual or a macro I can use so that I can move the horizontal column headings to line up veritcally with their respective cost center?

Any help or suggestions would be greatly appreciated!

Attached (if I uploaded this correctly) shows the current lay out and the desired lay out I need.

Book1.xlsx

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[arlu1201]

You created a duplicate thread. Instead, you had to edit this thread.

Thread closed.