Hi, Q1 Below there is a list of names and i want to select only second names from the list. Alan Schoenberg Alan Barnes Alex Russell Amy Cox Amy Hunt Andy Gerbode Benjamin Patter Clytie Kelty Julie Kriz Liz Price Robert Waldorf Marina Lichtens Q2 From the full address i want to select only second name the data is in miss mode Alan Schoenberg, Ontario, United States of America Alan Barnes, United States of America Benjamin Patter, Australia Clytie Kelty, Denmark Julie Kriz,West, British Columbia Liz Price,Northwest Territories, United States of America Robert Waldorf, United Kingdom Marina Lichens, California, United States of America Q3 Below Product Name has been listed and i want only those observation in output if Product Name have Chair and Machine Staples Colored Bar Computer Paper Office Star - Ergonomic Mid Back Chair with 2-Way Adjustable Arms Bevis 36 x 72 Conference Tables Global Leather Task Chair, Black Bush Advantage Collection® Round Conference Table Global Stack Chair without Arms, Black Office Star - Ergonomic Mid Back Chair with 2-Way Adjustable Arms Global Leather Task Chair, Black GBC DocuBind 200 Manual Binding Machine Staples® General Use 3-Ring Binders Machine
... View more