Here is a small excerpt from a large spreadsheet (see #1 below). Many values in column 1 of this spreadsheet are (83520-9) and (74843-2). I'd like to populate the cells directly to the right of the cells with value (83520-9) with value (Permethrin .52%). I want it to look like (#2 below)
#1
83520-9 1/5/2015
33906-10 1/6/2015
74843-2 1/6/2015
74843-2 1/6/2015
74843-2 1/6/2015
#2
83520-9 Permethrin .52% 1/5/2015
83520-9 Permethrin .52% 1/5/2015
33906-10 1/6/2015
74843-2 1/6/2015
74843-2 1/6/2015
74843-2 1/6/2015
Thanks much
Gianpaolo
Bookmarks