Microsoft Query output to Excel Spreadsheet

We use Microsoft Query as a query builder and export the data to an Excel spreadsheet.  When the spreadsheet opens, Excel's column names ( A thru ZZ) appear with the Data Table's Field names just below.

These field names can be quite long with the resultant data displayed in the column under the field name just being 2 characters wide.  An example would be a Data Field name being displayed as "Branch Number" and the data itself being "01" or "02" or "03".  I can't modify the Field Name itself because of other software that is dependent on those Field Names for data.

I was thinking of formatting the Field Name as:
B  N
R  U
A  M
N  B
C   E
H   R

using a SQL statement of some kind in the original query to display it as shown.

The purpose of this is so that I can display more Field Names with data on the printed page.  Right now, (even in Landscape mode) I can't get all the data squeezed in that I want the end user to see.  If I could turn the Field Names on edge or even at a tilt:
B  N
 R  U
  A  M
   N  B
    C   E
      H  R

this would allow me to add more columns that would print on a single piece of paper.

Please Advise.
baleman2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Missus Miss_SellaneusCommented:
You can format your column headings to be at an angle. Highlight the row, press Ctrl-1, go to the alignment tab and adjust the orientation in the half-circle, or type in the degrees.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Daniel Van Der WerkenIndependent ConsultantCommented:
You could do like Missus Miss Sellaneus says and it would work like what I have in cell A1. If you want the results from B1, then do like I show:
Alignment SettingThen, squeeze the row down so it just holds two characters and type in the text: B N R U A M N B C E H R
You'll see the B1 cell display:
branch-number.png
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.