Results 1 to 3 of 3

Thread: Selecting values from different rows in a table and merge them in order in one row

  1. #1

    Question Selecting values from different rows in a table and merge them in order in one row



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

    Hi,

    I want to use a formula, or set of formulas, for selecting values from a data table were the number of values differ between rows (see attachment). I do not want to cut and paste or use any commands as I need to make this a executable function.

    For instance, 9 rows and 21 cols (as in attachment), in the first row i have 21 values, in the 2nd only 4 and in the 3rd I have 5 etc. I want to "merge" these values in order in a single row, i.e. from B2 to V2 (in this case) and then continue with B3 to E3, and B4 to F4 etc, all in a single new row.

    So in the table I have a total of 103 values in 9 rows, i want to sort them in a single row, i.e. from e.g. B15 to CZ15 (I think it will be CZ).

    Click image for larger version. 

Name:	My Table.PNG 
Views:	4 
Size:	23.6 KB 
ID:	2618

    Thanks!
    Fredrik
    Attached Files Attached Files

  2. #2
    Good morning,

    Please see the attached file.

    Best of luck,
    Attached Files Attached Files

  3. #3
    Quote Originally Posted by bgoree09 View Post
    Good morning,

    Please see the attached file.

    Best of luck,
    Thanks a bunch!

Posting Permissions

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