Transpose (switch) rows into rows. and columns into columns.

  • Hi


    i need to mark some row (which has some content written in), mark other row(with data too) and switch/transpose them mutual.
    when i was trying transpose method, which is using for switching rowns and columns, it wrote me error, that data are overlapping. it means it cant work on same things (rows > rows, columns > columns).


    simply i need from this:

    Code
    1. http://img405.imageshack.us/img405/1974/i93o.png



    make this:

    Code
    1. http://img580.imageshack.us/img580/3373/43vo.png




    ty

  • Re: Transpose (switch) rows into rows. and columns into columns.


    "Transpose" is usualy used in the matrix sense, i.e. changing
    ABC
    into
    A
    B
    C


    For swapping columns like you want, this code would do it



  • Re: Transpose (switch) rows into rows. and columns into columns.


    ty v much for reply
    but i'm not programmer/coder i dont know How, Where put it and how run it....

  • Re: Transpose (switch) rows into rows. and columns into columns.


    SOLVED by this elegant step by step guide. awesome. systematic, stepbystep, displayed instructions how to do it:

    Code
    1. http://www.extendoffice.com/documents/excel/590-excel-swap-rows-or-columns.html


    BUT i dont know three things:
    1, how to save that macro in my excel to be there forever prepared for use.
    2, how to make button in excel to run that macro by one click.
    3, how modify it, to not swap WHOLE rows, columnsm; but just few celles selected from it !


    ty guys