View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] johnchang007@gmail.com is offline
external usenet poster
 
Posts: 1
Default Group and Change Data Axis in Excel

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.