I would like Sheet1 to be filled in with the data provided from Sheet2. In my initial attempts I added the CONCATENATE column as a stepping stone but it is not necessary to me to use it. What I am trying to accomplish is pretty far from what I'm familiar and I appreciate any help or guidance!
I want a function to copy the listed columns in Sheet1(Location, Type, length etc.) from Sheet2. The problem I'm most uncertain with is that I need the function to additionally create new rows in Sheet1 if there is data for it in Sheet2.
For example, for G2K_G1_FB21 it needs to copy one row from sheet2 and place it the correction location on Sheet1 and add an additional row below it and also copy the other matched row (matched with G2K_G1_FB21)on sheet2.
I attached a sample spreadsheet in case my explanation is confusing.
EDIT: stnkynts code is exactly what I needed! Thank you Vikas_Gautam too!
Bookmarks