LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: Change Direction of Group/Outline Function Ray Carter Excel Worksheet Functions 5 April 3rd 23 07:46 PM
How can you change the x-y axis of data in an excel spreadsheet? CarloGesualdo Excel Discussion (Misc queries) 2 December 12th 06 06:12 AM
can't change how data on 2nd axis is being displayed Rebekah Charts and Charting in Excel 1 May 4th 05 02:51 PM
How do I change X-Axis values in a chart with 2 Y-Axis? ESGLCC Charts and Charting in Excel 1 May 4th 05 02:41 PM
how do i change data on the x or y axis... internet team Charts and Charting in Excel 2 January 11th 05 04:51 AM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"