Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Moving Cells by classification...???

  1. #1
    Guest

    Default

    Suppose I have a list as follows:

    Col A Col B
    -----------------
    part1 10
    part1 15
    part1 11
    part1 12
    part2 18
    part2 15
    part2 22
    part3 14
    part3 17
    part3 16
    part3 14

    How could I go through the list and output this?

    Col A Col B C D E
    ------------------------------------
    part1 10 15 11 12
    part2 18 15 22
    part3 14 17 16 14

    I know how to do this in C++ or any other programming language besides VB! But I'd like to learn. Need some automated way of doing this for a long, long spreadsheet. Any help is greatly appreciated.

    Steve





  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oops, I just figured out the wonders of the pivot table wizard! That solved it.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    With your data...

    {"part1",10
    ;"part1",15
    ;"part1",11
    ;"part1",12
    ;"part2",18
    ;"part2",15
    ;"part2",22
    ;"part3",14
    ;"part3",17
    ;"part3",16
    ;"part3",14}

    ...in cells A2:B12 enter the formula, =(A2<>A3)+0, into C2 and the formula, =IF(A2=A1,D1&","&B2,B2), into D2. Fill both of these formulas down to the last data row. Perform a Copy/Paste Special Values on columns C:D. Apply an AutoFilter on column C displaying and then deleting rows containing 0 in column C. Remove the AutoFilter, select column D, and choose the Data | Text to Columns... menu command specifying comma delimitation. Delete column C.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •