merge data rows

Greetings, I have 2 spreadsheets that I am working with who's data I am trying to merge so that each person will end up with only one row of data. One spreadsheet has the orientation completion date in it, while the other has the checkin date. I copied and pasted worksheet 2 into the bottom...

Hello all, I've got an Access select query with the following output: User City Travel Type Place Customer user1 Paris private must see Eiffel Tower user1Parisprivate user1 Paris private art Louvre Museum user1Parisprivate user1 Paris private art Orsay Museum user1Parisprivate user1...

Dear all, I have six different spreadsheet, each one having a total of 8 (A-H) columns (and various rows). The data have to with patents, and what I need is the following: some patents appear more that one times but each row has different values. What I need is to merge the duplicates but keep...

Hello there, We are doing a graduation project on an international airport, consist of scheduling flights on check-in counters automatically. long story short, we ended up with an excel sheet like this: Were y-axis are the check-in counters and x-axis is the timeline horizon (cell per...

I have a table that has data split between rows. I need to merge the data, if possible. Please see example. If "Name" is the same, insert content from cell "B2" into "D2" and place content from "C5" into "E2". I think I could build the formula if the number of identical "Name" rows were always...

I have 5 Scenarios that include IF/THEN rules with the ultimate goal of merging 2 rows of data. In a nutshell, the code should start at the top (row 3) and attempt to merge the row beneath it -- into it (IF it's a match)-- to ensure the top row has the MOST UP-TO-DATE content. Once it is done...

Hello I have a data set like this on about 200 animals so about 1000 rows:​ Cat Rabies # Microchip # Collar # Clinic # (each number below is in a different column - each time I edit this post they all snap back to the cat's name!) Shaggy...