Group and Change Data Axis in Excel

[johnchang007]

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.

 

[Guest]

That's a pivot table...

Highlight your table
Data->Pivot Table...
Just Hit Finish.

In your pivot table, drag the name and ID into the column fields
In the Row field drag your Variable
In the Data Fields put your Credits.

To get rid of subtotals, right click in one of the name cells, select field
settings, and change Subtotals to None.