1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Copying a list into Comma separated values and transpose the list as well

Discussion in 'Business Applications' started by mihaufo, Mar 25, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. mihaufo

    mihaufo Thread Starter

    Joined:
    Mar 15, 2012
    Messages:
    41
    Hi,

    Attached is an excel sheet (Book1), in which I need to Copy the items from A1 to D3 in a comma separated value as in F.

    For example,
    A1 A2, A4, B4, C4, D4
    A1 A2, A5, B5, C5, D5 and so on.

    And transpose the above sheet as in Sheet2.

    Thanks you,
    miha
     

    Attached Files:

  2. kumar1111

    kumar1111

    Joined:
    Mar 6, 2012
    Messages:
    50
    Review your Sheet and let me know do you need in this fashion

    Parent Class: Sprocket Child: Simplex Pitch
    Unit
    Teeth
    Type


    This is what i get on transposing, if this the case then just confrim it so I can give you the code.
     
  3. mihaufo

    mihaufo Thread Starter

    Joined:
    Mar 15, 2012
    Messages:
    41
    No, not like that, I don't need the Parent Class and Child. I need the sheet to be first as in Sheet1 Column F, like this:
    Sprockets Simplex, 1, Inch, 24, 80B

    Then the transpose to be like Sheet 2 Column C and D.

    Or I can just say, From Sheet 1 (Column A to D), I need the output as in Sheet 1F and in Sheet 2.

    Hope you understood.
    Thanks,
    Inayath
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1046529