Hi the description of my problem may not be the best.
This is my data set up:
Cell A1 contains the text: Validate CB staging table fields map correctly to the L_CB_Joint_Share table without any transformation or data generation taking place.
Cell A2 contains the text: Validate for target table L_CB_Joint_Share the "Auto Generated" and "Event_Log_Key" field data is auto created and not based on source data tables
Cell A3 contains the text: Validate CB staging table fields map correctly to the L_CB_Joint_Share table based on the field specific transformation rules
The 1 word that is common to all 3 cells is the word "L_CB_Joint_Share".
I wanted to see is there a way in excel where I can have the word (or a variation) "L_CB_Joint_Share" auto populated to the other 2 cells in this case Cell A2 and A3.
The common word will change from test case to test case but the rest of the wording for each of the cells will always be the same.
Bookmarks