I am using Power Pivot to pull in data from a SSAS tabular model and then creating an excel worksheet with data from the Power Pivot model. Unfortunately, the headings always include tablenamecolumnnamecolumnname (i.e. CustomerCustomerPhoneNumberCustomerPhoneNumber and PhoneNumber). If I have a data base table or another worksheet that has a column for the long name and a column for the name I want for the column, would it be possible to automate the renaming of the headings with special programming in Excel? If so, how? I haven't had any experience with doing anything like this. Any help will be greatly appreciated!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel 2013 Renaming column headings automatically
- Thread starter racand
- Start date
Similar threads
