Poker
There is currently 1 person viewing this thread.
21 Jan 10
13:48
Joined:
Date Joined:
04 Jun 04
Been yonks since ive used this so cant remember a thing...
Say you have data in the form
1
MR A Smith
024 111111
101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
2
MR B Smith
024 222222
102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
3
MR C Smith
024 333333
103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
4
MR D Smith
024 444444
104 ANY ADDRESS, Coventry, West Midlands, POSTCODE
5
MR E Smith
024 555555
105 ANY ADDRESS, Coventry, West Midlands, POSTCODE
6
MR F Smith
024 666666
106 ANY ADDRESS, Coventry, West Midlands, POSTCODE
all this appears in A1:A24
The list in column A is lot lot bigger than this but using 6 contacts as an example
[u]QUESTION[/u]
how do i get it so it appears on a new sheet as follows
A1:B1:C1:D1 would be 1,MR A Smith,024 111111,101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
A2:B2:C2:D2 would be 2,MR B Smith,024 222222,102 ANY ADDRESS, Coventry, West Midlands, POSTCODE
ETC ETC
not explained it too well but hope its clear enough...
THANKS IN ADVANCE , SHERRIFF
Say you have data in the form
1
MR A Smith
024 111111
101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
2
MR B Smith
024 222222
102 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
3
MR C Smith
024 333333
103 ANY ADDRESS, Binley, Coventry, West Midlands, POSTCODE
4
MR D Smith
024 444444
104 ANY ADDRESS, Coventry, West Midlands, POSTCODE
5
MR E Smith
024 555555
105 ANY ADDRESS, Coventry, West Midlands, POSTCODE
6
MR F Smith
024 666666
106 ANY ADDRESS, Coventry, West Midlands, POSTCODE
all this appears in A1:A24
The list in column A is lot lot bigger than this but using 6 contacts as an example
[u]QUESTION[/u]
how do i get it so it appears on a new sheet as follows
A1:B1:C1:D1 would be 1,MR A Smith,024 111111,101 ANY ADDRESS, Coventry, West Midlands, POSTCODE
A2:B2:C2:D2 would be 2,MR B Smith,024 222222,102 ANY ADDRESS, Coventry, West Midlands, POSTCODE
ETC ETC
not explained it too well but hope its clear enough...
THANKS IN ADVANCE , SHERRIFF
sort by:
Show
per page
Replies: 4
|
By:
'Text to Columns' is the tool you are looking for should be under the 'Data' header
|
|
By:
little bit of further help please... in s sheet 7 worksheet where i am importing data from the previous sheet
if you have a1=Sheet6!A1 a2=Sheet6!A6 a3=Sheet6!A11 and i want to carry on this series downwards eg in a4 i would have =Sheet6!A16 and then A21 etc etc.. how do i drag the formulas downwards or what function do i use in order to maintain the series my head fried at min |
|
By:
$ signs used i think either side of the constants and the variables left alone and excell should autofill the difference needed
|
|
By:
cant seem to get it to do it mandy... im not sure if its index function instead..
|