Can you please help me figure out how to consolidate each value for duplicate numbers into one cell?
Please see the example of what I need in"Example" tab in the attachment. For STRT_DT and SITE_DISPL_DT columns in DUPLICATE VALUE table I will need to list these values in two different columns if there are two dates per SKU_ID. And I will need to summarize the values in the below columns for the same SKU_ID.
COM STORE
FFLQTY FFLREV DC_ASP RET_QTY RET_REV RET_ASP
Thank you so much!
Bookmarks