Tuesday, August 28, 2012

yogi_Merge Data From Different Fields In Two Sheets Into A Master Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #718   Aug 28, 2012     www.energyefficientbuild.com.

user miba said: (http://productforums.google.com/forum/?zx=4uvknqql63q3#!category-topic/docs/spreadsheets/TZm5R4jCLTg)
merge 2 spreadsheet into one
Hello,
Probably easy thing but I've tried to find example on the forum but without success.
I would like to marge 2 spreadsheet based on the ID column to the one. As a result I would like to have in the one row all valuesd for the same id.
Can you help me with a query?
Thanks in advance,
Milosz
-----------------------------------------------------------------------------------

it turns out that the user means merge data from different fields of two sheets into Master sheet of the same spreadsheet
following is a solution to the problem