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
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 ?
https://docs.google.com/
manny thanks !!!
---------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment