Merging rows

Copper Contributor

I need to merge rows in my spreadsheet. This is a sample there are numerous rows that need to be merged. So that there is only one Farm name for given date.


NoFarmFruitSale DateApples SoldGranny SmithFujiGolden DeliciousRed DeliciousEmpireOtherMcintosh
5678Apple Grove Farm 22328Apples01/10/20205   121 
5678Apple Grove Farm 22328Apples01/10/2020152 1471 
2 Replies
best response confirmed by Lennox2525 (Copper Contributor)


I'd create a pivot table based on the data. Display it in tabular layout and turn off all subtotals and grand totals.

See the attached workbook,

Perfect - Thank you @Hans Vogelaar