If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Creating one record out of several records

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.

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.

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

Creating one record out of several records

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

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.