| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Join multiple rows into columns
I have survey data from a database export in 3 columns. Each question is one
a seperate line with the answer and the person who did the survey, so it looks like Question User Answer q1 user1 a1 q2 user1 a2 q1 user2 a3 q2 user2 a4 I want it displayed where the rows are combined with the question on top so you have User q1 q2 user1 a1 a2 user2 a3 a4 Pivot tables would work except the data field will not display the actual values. Cut & Paste Transposing would only work with alot work. Since this has to be done by an end user exporting to a database and then doing a quick select is not an option. Can someone please point me to a solution or is there some excel related terms I should be using in my searches? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditionally join rows | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| join rows? | New Users to Excel | |||
| join columns, keep both values | New Users to Excel | |||
Threaded Mode
