Suoritettu

Merging data from multiple excel sheets into one sheet - repost

I have an excel workbook with 5 tabs. I need the data in tabs 2 through 5 merged into the data set on tab 1 so that all the lines of the data related to one person are on the same line. There are two columns of data that are common across all five data sheets (first and last name) that can be used to match data. This is NOT a simple "sort" and cut and paste job because not every data sheet has the complete set of data. Someone familiar and comfortable with vlookup may be able to merge first and last name together in each sheet and use vlookup to make this happen quickly.

I want all the data from tabs 2 through 5 moved over to tab 1 and assigned to the correct person.

I will send the file to the top candidates so you can review but as point of reference there are approximately 1,600 rows of data in tab 1 and approximately 8 columns of data. Again, there are two columns of data (first name and last name) in each sheet that are common - if you know how to merge two columns into one this gives you a unique column across the 5 sheets to link on.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: one tabs, how to use data entry in excel, Vlookup, sort excel, sheets, merge data, line sheet, excel vlookup, data merge, data entry in excel sheets, need excel data person, across multiple, multiple excel, link excel workbook vlookup, excel unique, 600 lines, match merge excel, point excel, data merging, excel sheets merge

Tietoa työnantajasta:
( 3 arvostelua ) Chester, United States

Projektin tunnus: #4313652

Myönnetty käyttäjälle:

mrbrave

I am expert at this work....Lets start now and get it done very quick.

$30 USD 1 päivässä
(59 Arvostelua)
5.2

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

Innovative116

Hi. I am interested in the project. Please check private message for more details. Thank you

$80 USD 1 päivässä
(71 arvostelua)
6.8
sy3d

Consider it done with 100% accuracy, please check pm for further details .. thx

$99 USD 2 päivässä
(105 arvostelua)
6.2
inzaghi2006

Hi, It is very simple, please contact me to get it done soon. Thanks

$70 USD 2 päivässä
(23 arvostelua)
5.0
THEHIGHTECHSOL

Greetings , thank you for posting your project here on freelancer.com

$30 USD 1 päivässä
(28 arvostelua)
4.9
nagendraraja

Dear Sir, We are ready to start and fulfill your requirement on time. Please check your inbox for details about us. Regards Rajaa

$60 USD 1 päivässä
(19 arvostelua)
4.5
seaanddream

Hi, excel macro expert here.

$60 USD 3 päivässä
(5 arvostelua)
2.8
Evs1

***We exist in world's Top 10 Virtual Assistant & Data Entry Companies*** Please check PMB for complete details.

$150 USD 1 päivässä
(2 arvostelua)
2.1
Ashish91up

i will do this work

$100 USD 7 päivässä
(0 arvostelua)
0.0
westechms

I will write a small external program that will input your spreadsheet and output exactly what you want. Work will be quick and exact.

$125 USD 2 päivässä
(0 arvostelua)
0.0
tsinder

Hi, Excel expert here having vast experience in working on Excel including small excel software and games. I shall do be able to do it easily. Thanks! Regards, DK

$70 USD 2 päivässä
(0 arvostelua)
0.0