Hello – is there a way to automatically amalgamate all the same items in Column F and then include all items in their respective rows and insert into a new worksheet (ie. Together)?
For example – how can excel automatically pull together all “apples” in Column F, then insert in the new tab called together presenting data in the rows together in 1 row. I have indicated how I would like to have the data presented in row 4 by indicating & (and), + (sum), top sum(Look at similar items in column R and insert the one with the great IN sum in Column AF)
I have attached a file. The “list” tab is where the data is and the “together” tab is where amalgamated data needs to be inserted. This needs to be done for all items in Column F. If a row in column F is blank, the data should not be transferred to the “together” tab.