Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


I need help in Excel 2007

Posted on 2014-01-08
Medium Priority
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

Desired result

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

How can I do this?  Thank you very much in advance.
Question by:mainrotor
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 52

Accepted Solution

Rgonzo1971 earned 1000 total points
ID: 39765921

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

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

LVL 23

Assisted Solution

NBVC earned 1000 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.
LVL 23

Expert Comment

by:Patrick Bogers
ID: 39765929

Could you post your xls form?

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

715 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