Merging rows

[Lennox2525]

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 Sold	Granny Smith	Fuji	Golden Delicious	Red Delicious	Empire	Other	Mcintosh
5678	Apple Grove Farm 22328	Apples	01/10/2020	5				1	2	1
5678	Apple Grove Farm 22328	Apples	01/10/2020	15	2		1	4	7	1

[#2 · Accepted solution]

@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,

[#3]

Perfect - Thank you @Hans Vogelaar