I need help in Excel 2007

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
mainrotorAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
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
 
NBVCConnect With a Mentor Commented:
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
 
Patrick BogersDatacenter platform engineer LindowsCommented:
Hi,

Could you post your xls form?
0
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.

All Courses

From novice to tech pro — start learning today.