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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by barbcouilliard
-
How to transpose multiple columns of data to multiple rows
thank you xlhelp, appreciate your help very much. It's true if the cross tab query works it will be easier, but it's always good to have options.- barbcouilliard
- Post #14
- Forum: Microsoft: Office
-
How to transpose multiple columns of data to multiple rows
because putting the Codes in the Values section of a pivot table treats them as numbers and I get 0's instead of what the code is. the codes are text. ie, some are 01, 02, 03, etc.- barbcouilliard
- Post #11
- Forum: Microsoft: Office
-
How to transpose multiple columns of data to multiple rows
If the Crosstab query in Access works like a pivot table in Excel, it will not work for this. I already tried that. I will try the crosstab query but I appreciate the other suggestions.- barbcouilliard
- Post #9
- Forum: Microsoft: Office
-
How to transpose multiple columns of data to multiple rows
Excel data: Namekey Category Category Code SmithJon Category 1 56 SmithJon Category 2 19 SmithJon Category 3 42 Needs to be in this format: Namekey Category 1 Category 2 Category 3 SmithJon 56 19 42- barbcouilliard
- Post #3
- Forum: Microsoft: Office
-
How to transpose multiple columns of data to multiple rows
I'm trying to figure out how to get data that is in multiple rows and columns, into one row per namekey with all the associated data to that namekey on the same row. I'm attaching screen shots of what the data currently looks like and how I need to look. End result is I need to load the data...- barbcouilliard
- Thread
- Replies: 14
- Forum: Microsoft: Office
