Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2007
    Posts
    51

    Wink Unanswered: Creating one record out of several records

    I have these records:
    A B C D
    1 eventi 7 555825 null
    _____________________________________
    2 512914 null 500 null
    ______________________________________
    3 22205126 null null 600

    4 1816695 null 300

    I need to join the four records: all fields of record 2, 3 and 4 must be added after the last column of record 1.
    Since I have to repeat this operation for many records, it would be a long
    work to simply copy each record at a time and paste it in the first record,
    so I'd like to select all the records that I want to copy and paste them in the first record in a single operation.

    Another question: could you explain to me how macros work?

    Thank you in advance.

    Anna - Verona (Italy)

  2. #2
    Join Date
    Feb 2007
    Posts
    348
    so as I understand it you want the records to be
    1 ...old data... eventi7555825
    2 ...old data... 22205126600

    and so on

    so you make column A in row 1 (or if 1 is labels replace 1 with the correct row) say the following
    =concatonate (A1,B1,c1,D1)

    then after you press enter and teh values fill in, hover on the bottom right corner of the cell and you'll get a black cross. click and drag down and it will fill in the formulas adjusted for the correct rows.

  3. #3
    Join Date
    Apr 2007
    Posts
    51

    Creating one record out of several records

    What I want to do is to maintain the records the way they are, only I want
    them to be displayed in one single record, in order.
    For example:

    A1 B1 C1 A2 B2 C2 A3 B3 C3
    (A2 B2 C2 composed the second record and are now moved to the first
    record, after the fields of record one. The same for record three).

    Thank you

  4. #4
    Join Date
    Feb 2007
    Posts
    348
    So you want it to say the following?

    1 eventi 7 555825 null 512914 null 500 null 22205126 null null 600 1816695 null 300
    ______________________________________
    2 512914 null 500 null
    ______________________________________
    3 22205126 null null 600
    ______________________________________
    4 1816695 null 300

    You could make D1 say =A2 and E1 say =B2 and so on (use autofill). If you don't want to old format to still exist you could hide it or you could copy your first row and paste special > values. of course this is going to be an odd way to present information and thecolumn limitation is much smaller than row limitation

  5. #5
    Join Date
    Apr 2007
    Posts
    51

    Creating one record out of several records

    Quote Originally Posted by starkmann
    You could make D1 say =A2 and E1 say =B2 and so on (use autofill). If you don't want to old format to still exist you could hide it or you could copy your first row and paste special > values. of course this is going to be an odd way to present information and thecolumn limitation is much smaller than row limitation
    What is AUTOFILL?

    Thank you.
    Anna

  6. #6
    Join Date
    Feb 2007
    Posts
    348
    When you have a pattern in cells like:
    1,2,3
    a,b,c
    Monday,Tuesday,Wednesday
    or want to repeat the same cells over and over:
    Apple, Bananas, Pears

    you can highlight what you have already typed and put your cursor over the bottom right corner of what it highlighted, you should get a black + sign.Click and drag and it should fill in the rest of the pattern or repeat what you have selected if it isn't a known pattern.

    It works too with formula cells, if you want to perform the same action on each cell, fill in a couple then autofill and they will be incremented as expected.

    here are some references
    http://exceltips.vitalnews.com/E002_AutoFill.html
    http://download.microsoft.com/docume...s_autofill.htm
    http://www.functionx.com/excel/Lesson04.htm

Posting Permissions

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