• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. R

    Transposing a row into multiple columns

    Luke M, The formula did exactly what I needed to do, it saved me a lot of time! Although I was having trouble applying it for a bigger dataset. For example: 1 2 3 4 5 6 7 8 9 10 11 12 to 1 2 3 4 5 6 7 8 9 10 11 12 The solution I found (I needed to stop playing with...
  2. R

    Transposing a row into multiple columns

    Thanks for explaining the breakdown, I appreciate it!
  3. R

    Transposing a row into multiple columns

    I am trying to transpose a row of data into 2 columns. Here is an example: 1 2 3 4 5 6 to 1 2 3 4 5 6 I have seen some formulas around here that were for the opposite (columns to row) but I wasn't quite able to figure out how to modify them to help me. So hopefully someone can help...
  4. R

    Hello .. Introduce yourself

    Hi My name is Ryan and I live in Nebraska. I always felt excel was such a great tool, and after seeing this website, I have yet to see the full potential!
  5. R

    Transposing multiple rows into one column

    Hello, I am almost positive this is what I need, but mine is in opposite direction and I don't really understand how the formula (that LukeM posted) works to tranpose it. This is what I need done, hopefully someone can help. 1 2 3 4 5 6 to 1 2 3 4 5 6
Back
Top