Solved

I need help in Excel 2007

Posted on 2014-01-08
3
242 Views
Last Modified: 2014-01-08
Hi Experts,
I have an Excel 2007 spreadsheet with values in a column.  How can I get those values to display accross a row as headers (see example below)?

Current Values in Column A

Column A
--------
Snacks
Sodas
Napkins

Desired result

Column A       Column B                       Column C
--------                      --------                      --------
Snacks            Sodas            Napkins



How can I do this?  Thank you very much in advance.
mrotor
0
Comment
Question by:mainrotor
3 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 250 total points
ID: 39765921
Hi,

Select the cells you want to rearrange then Click Copy (Ctrl-C)

and then by Paste / Paste Special and tick Transpose and OK

Regards
0
 
LVL 23

Assisted Solution

by:NBVC
NBVC earned 250 total points
ID: 39765922
You can copy, then Paste Special and select Transpose.

or you can use a formula:

=INDEX(A:A,COLUMN($A$1:A$1))  copied across. Then you would need to copy that and paste special as Values over itself, before you delete the original.
0
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39765929
Hi,

Could you post your xls form?
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question