Results 1 to 2 of 2

Thread: Positioning data in single column for a graph.

  1. #1

    Positioning data in single column for a graph.

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am getting data from a wireless tag in the next format
    Reading1, Reading2, Readin3
    Reading4, Reading5, Reading6

    So I have threee columns and several hundred rows. Could you please tell me if there is a way to organise them in order into a single column?

    Thank you,


  2. #2
    Hi Javier,

    There are multiple way you can do this, with function or vba Code. let me try to make your life easy with function itself.

    1. Copy (Ctlr+C) all the data (3 columns and all the rows) and go to different sheet / cell and paste it as transpose (paste special - Transpose)
    2. Cut the second column and paste it below first column and do the same for 3rd column.

    Hope I am not confused with my solution : -)

    Let me know if you can make it or not..


Tags for this Thread

Posting Permissions

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