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

Select Row Value as Column

Status
Not open for further replies.
BigHoss

BigHoss

Programmer
Joined
Mar 17, 2010
Messages
1
Location
US
Hi all,
I need to turn this.......
#(integer) Name(string)
1 Name1
2 Name2
3 Name3

into this (all column headers)......
1 Name1 2 Name2 3 Name3
 
Sort by date Sort by votes
Look at the FAQ's there are at least a couple that deal with this i.e. faq183-6466 and faq183-6485

Hope this helps


djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!
 
Upvote 0 Downvote
if you want that in actual columns. Do a quick search on Pivot tables.

Simi
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
Cpreston
  • Locked
  • Question Question
Group results into one row
2
Replies
37
Views
3K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question Question
Consolidate multiple rows into single row
Replies
4
Views
2K
Chris Miller
Chris Miller
bharons
  • Locked
  • Question Question
Pick up value from combobox
Replies
0
Views
790
bharons
bharons
peac3
  • Locked
  • Question Question
split one row into multiple rows... help pls
Replies
12
Views
2K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top