January 14, 2011 at 4:42 am
Hi there,
I have a set a data with the same data in all columns besides the tel no column and un. I have to import the data into a table and each telno no for each location name into a different column eg:
Location IDTelephone NoLocationLocation CodeLocation Owner
15558754Arizona5555Abraham Lincoln
15559542Arizona5555Abraham Lincoln
15555623Arizona5555Abraham Lincoln
15551215Arizona5555Abraham Lincoln
15551132Arizona5555Abraham Lincoln
15553211Arizona5555Abraham Lincoln
25358941New York 4444Anrnold Null
2535412New York 4444Anrnold Null
25354123New York 4444Anrnold Null
25354789New York 4444Anrnold Null
25354562New York 4444Anrnold Null
25356541New York 4444Anrnold Null
I need to write a script that will return Arizona in one field but have the different telephone numbers in different columns. eg: telephone no1, telephone no2, telephone no 3 etc.
Can anyone please assist?
Regards
IC
January 14, 2011 at 5:19 am
Please have a look at the CrossTab article referenced in my signature.
I'm sure this concept will help to resolve the issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply