Izila
New Member
- Joined
- Aug 27, 2019
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hi,
I have a large excel spreadsheet that repeats every two rows by id and year. however, some variables are constant( no command needed), some need to be averaged and added. I need to merge the two rows repeating, there are over 1000 rows repeating in the dataset. I have illustrated with an example below. how do I merge the two rows together and paste them rows into a new spreadsheet for each ID?
edited row:
I have a large excel spreadsheet that repeats every two rows by id and year. however, some variables are constant( no command needed), some need to be averaged and added. I need to merge the two rows repeating, there are over 1000 rows repeating in the dataset. I have illustrated with an example below. how do I merge the two rows together and paste them rows into a new spreadsheet for each ID?
ID | Year | house number | Children (constant) | Adults (constant) | Income (Avg) | Distance to work (sum) | milk price (Avg) | Employees at Work (sum) |
236 | 2013 | 10 | 3 | 4 | 6 | 6 | 12 | 11 |
236 | 2013 | 10 | 3 | 4 | 4 | 4 | 8 | 9 |
edited row:
ID | Year | house number | Children (constant) | Adults (constant) | Income (Avg) | Distance to work (sum) | milk price (Avg) | Employees at Work (sum) |
236 | 2013 | 10 | 3 | 4 | 5 | 10 | 10 | 20 |
Last edited: