Results 1 to 3 of 3

Thread: Transposing formula

  1. #1

    Transposing formula



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

    Hello,

    I am new to excel and am struggling to find an appropriate formula to transpose data from the current format:


    KEY DATA TITLE(A) 1
    additional info 2
    additional info 3
    additional info 4
    additional info 5
    KEY DATA TITLE(B) 1
    additional info 2
    additional info 3
    additional info 4
    additional info 5
    KEY DATA TITLE(C) 1
    additional info 2
    additional info 3
    additional info 4
    additional info 5

    etc...

    To the following:

    KEY DATA TITLE(A) 1 2 3 4 5
    additional info
    additional info
    additional info
    additional info
    KEY DATA TITLE(B) 1 2 3 4 5
    additional info
    additional info
    additional info
    additional info
    KEY DATA TITLE(C) 1 2 3 4 5
    additional info
    additional info
    additional info
    additional info

    Any advice on this matter would be hugely appreciated!!
    Cheers!

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Try look here or here or here
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Aye, but its the gaps in the rows that are giving me grief, not the actual transposing.

Posting Permissions

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