Sunday, July 15, 2018

I will merge excel tables or data into one master table

I will merge excel tables or data into one master table












About:

If your data is scattered, and is on more then one table/source, and you want to combine these data into one single data / table, irrespective of unique columns, then here you have reached at right place. I will merge all of your data into one master data so that it can be used for analysis and reporting. No Duplication of columns, and mixing of data. Here is an example

Table 1 has Data
ID, Date, Receipts, Product 
01,02-Sep, $1,000, XYZ
05,09-Sep, $500, ABC

Table 2 has Data
ID, Date, Payments, Products, Terms
02, 05-Sep, $500, ABC, 90 Days
05, 07-Sep, $1,100, XYZ, 30 Days

The Master Table would have the following
ID, Date, Receipts, Products, Payments, Terms
01,02-Sep, $1,000, XYZ
05,09-Sep, $500, ABC
02, 05-Sep,               ABC,                $500, 90 Days
05, 07-Sep,               XYZ,              $1,100, 30 Days

Reviews


khadijakubra:excellent work. knows merging excel tables or data into one master table proficiently. I will always hire him

waqasabid007:Great experience

edahlen241:I would HIGHLY HIGHLY recommend waqasabid007. Extremely good communication. He asked many questions, gave samples and was clear regarding the task requirements. A true professional. I greatly appreciate the quality of his work.

waqasabid007:Wonderful Experience to work for Erik (edahlen241)

khadijakubra:excellent work. knows merging excel tables or data into one master table proficiently. I will always hire him


No comments:

Post a Comment