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

Split Rows into Columns

Status
Not open for further replies.
susanh

susanh

MIS
Joined
Jan 16, 2001
Messages
229
Location
US
Dumb Question, don't even know if I can do it. I want data from several rows to be moved into separate columns.
Can I do this? If so, How?
Sue
 
Sort by date Sort by votes
Copy, Paste-Special with "Transpose" checked.
 
Upvote 0 Downvote
1. Select what you want to move and choose Copy
2. Right-Click where you want it to go and choose
Paste Special
3. In the Paste Special dialog box, check Transpose
and click OK.


 
Upvote 0 Downvote
Thank You, Thank You, Thank You!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
771
remeng
remeng
Kim296
  • Locked
  • Question Question
Need Genius Help - Finding multiple duplicates between columns - EXCEL
2
Replies
38
Views
3K
mintjulep
M
GPnew
  • Locked
  • Question Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
2K
combo
combo
TrekBiker
  • Locked
  • Question Question
Use 2 columns in Detail Section of report
Replies
8
Views
1K
TrekBiker
TrekBiker
bkoopers
  • Locked
  • Question Question
Problem with Excel pasting into filtered cells
Replies
1
Views
711
combo
combo

Part and Inventory Search

Sponsor

Back
Top