Forum Discussion
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 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 |
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,
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 HansVogelaar
