Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro to convert column values to row values

Status
Not open for further replies.
Brianfree

Brianfree

Programmer
Feb 6, 2008
220
GB
Hi i have 1 row with data in each column. I need to convert this to 1 column with data in each row? Is there a easy way to do this?

Many thanks,

Brian

 
Sort by date Sort by votes
Edit>Copy

Edit>PasteSpecial>Values & Transpose

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
2K
remeng
remeng
OCM
  • Locked
  • Question
lookup values
Replies
2
Views
316
OCM
OCM
PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
902
dhookom
dhookom
techguy2010
  • Locked
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
540
techguy2010
techguy2010
T
Can I move My Apple Mail Emails to Outlook?
Replies
2
Views
553
PatrickRoggers
PatrickRoggers

Part and Inventory Search

Sponsor

Back
Top