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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paste Format

Status
Not open for further replies.
vaughn9

vaughn9

Technical User
Sep 23, 2001
183
Does Excel allow me to copy items in a column (down) and paste those same items in a row

example

Column A

John
Peter
Fred
Mark

can I copy the above and paste them so that they now appear in one row but in the same order like this.

John Peter Fred Mark
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
400
combo
combo
bhujanga
  • Locked
  • Question
Prevent Converstion of Long Numeric Strings to Exponential Format 1
Replies
4
Views
333
remeng
remeng
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
741
SkipVought
S
renigar
  • Locked
  • Question
Excel custom format data validation 4
Replies
13
Views
291
Deniall
Deniall
mart1000
  • Locked
  • Question
condition format on date and contents
Replies
3
Views
160
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top