Monday, February 9, 2015

yogi_Given A Table Of Values -- Set It Up In List (DataBase Style)

             Google Spreadsheet   Post  #1890
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-09-2015
post by  taton:
Import, filter and transpose
Hi,

I  have some data in one sheet, i need to import and transpose some data to another sheet but only the row that has some product on it.

this is how is look (sheet # 1)

Name          Product A        Product B       Product C
John                  5                     3                       4
charly                                                                7        
gabe
richard                                      9                         


after Import should be like this. (sheet #2)

John       Product A   5
John       Product B   3
John       Product C   4
charly     Product C   7
richard    Product B   9

there is a formula to do this ?



manny thanks !!!
---------------------------------------------------------------------------------------------------------------------------------------