Access Database Query

$30-250 USD

Закрито

Опублікований

over 15 years ago

$30-250 USD

Оплачується при отриманні

I have one table which has multiple contacts listed on each row for the same companies. I need a way to take the list and convert it from showing several contacts for each company on several rows to columns next to the company. The attached excel file gives an example. Sheet one is the original table/list and sheet two shows the result. You will see in sheet two that there is one company listed per line with the contacts listed as first first_2, first_3, etc. You can use the web address as the unique identifier. I need a query for this that I can use in access for a table with these specific columns. I need this as soon as possible.

C Programming

Script Install

ID проекту: 335623

Про проект

13 пропозицій(-ї)

Дистанційний проект

Активність 15 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

13 фрілансерів(-и) готові виконати цю роботу у середньому за $49 USD

@rajtuhin1

Master in .NET and having vast experience in Excel data reformat. Select me ASAP. You will get results within 4 hours. Thanks.-TUHIN

$30 USD за 0 день

5,0

(30 відгуки(-ів))

6,4

@simonchen

hi, dear sir: i'm serious. pls check P.M.B , thanks.

$30 USD за 0 день

4,7

(34 відгуки(-ів))

6,1

@tonmay

It should be a very easy work for me. Waiting for your selection to proceed on. Thanks, Tonmay

$30 USD за 1 день

4,8

(40 відгуки(-ів))

6,1

@HussienSharaf

HI, i made similar tasks like this one. plz check PM thanks

$120 USD за 2 дні(-в)

5,0

(13 відгуки(-ів))

4,8

@cnut17

this could be done via the cross analysis function if there was only one contact info to dispatch or if they could be merged in one cell. to get exactly this layout, a little VBA code has to be written. what if you get more then ten contacts ? do you expect truncation of the extra ones or split more columns ?

$50 USD за 3 дні(-в)

5,0

(4 відгуки(-ів))

4,1

@LexelDesigns

Please see PM for further details.

$100 USD за 1 день

5,0

(1 відгук)

3,4

@VisionsUnleashed

Please check PMB for details. Thank you.

$50 USD за 1 день

5,0

(1 відгук)

2,8

@dataconsultants

Please check PMB for details, Thank you

$35 USD за 1 день

5,0

(3 відгуки(-ів))

2,4

@divamL

I'll do it!

$30 USD за 0 день

0,0

(0 відгуки(-ів))

0,0

@mnash0915

I can do this for you quickly and easily. I would be happy to help. Thanks!

$50 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@PACCESS

I can do this give me a shot!

$50 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@RFORD29

Hi, I could do this very quickly I am looking for experience on how this site works. I could write teh SQL query so that you just past it into your database run it and all your problems are solved. Dont think th low price is because of inexperience I have been designing/implementing large datbases for the last 6 years and this sounds like a straight foward duplication removal.

$30 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@SimonH77

I'm an MSAccess systems developer with over 10 years experience in developing complex MSaccess systems for blue chip companies and have previously written a facility within MSAccess (using VBA) to merge multiple rows into one row with multiple sets of fields.

$35 USD за 2 дні(-в)