Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a dataset with the columns: User, ID, Variable(A-F), and
Credits. If the user has more than one variables, it shows up more than once. For example: User ID Variable Credits Bob 123 A 5 Bob 123 C 10 Bruce 345 D 12 Bruce 345 F 13 I would like to reorganize the dataset in such a way that the user and ID only shows up once and have a column for each of the variables with the corresponding credits such as: User ID A B C D E F Bob 123 5 10 Bruce 345 12 13 Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: Change Direction of Group/Outline Function | Excel Worksheet Functions | |||
How can you change the x-y axis of data in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
how do i change data on the x or y axis... | Charts and Charting in Excel |