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)

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.

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

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

What is AUTOFILL?

Thank you.
Anna

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