Forum Discussion

Lennox2525's avatar
Lennox2525
Copper Contributor
Mar 15, 2023
Solved

Merging rows

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.   No Farm Fruit Sale Date Apples ...
  • HansVogelaar's avatar
    Mar 15, 2023

    Lennox2525 

    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,

Resources