Sebbie
New member
- Joined
- Feb 21, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hello,
I am really stuck on this and i could do with some help converting thousands of lines of data in excel into a totally different format for our company's move to a database management, system.
The tricky part is, our existing data works as follows, property reference (UPRN) runs down a column, elements run along the top row and the cells in between are for the data.. like so:
The database required details to be listed quite differently, the above for one property would be like this.
The new format requires a new line for every UPRN (property) this is somewhat scaled down but should indicate the issue, I have tried all sorts of methods but it is very time consuming, my source includes some 200 element column headings and 7500 UPRN's per sheet, and i have about 5 sheets to process.
I would be really really grateful for any advice on what feature excel has that might be able to assist me in this.
Thank you
I am really stuck on this and i could do with some help converting thousands of lines of data in excel into a totally different format for our company's move to a database management, system.
The tricky part is, our existing data works as follows, property reference (UPRN) runs down a column, elements run along the top row and the cells in between are for the data.. like so:
UPRN | Roof Tiling | Leadwork | PVCu | Kerb edgings |
88102 | 1 | 21 | 12 | 7 |
88104 | 1 | 2 | 12 | 8 |
88108 | 1 | 15 | 12 | 1 |
88109 | 1 | 5 | 12 | 3 |
The database required details to be listed quite differently, the above for one property would be like this.
UPRN | Element | QTY |
88102 | Roof Tiling | 1 |
88102 | Leadwork | 21 |
88102 | PVCu | 12 |
88102 | Kerb edgings | 7 |
The new format requires a new line for every UPRN (property) this is somewhat scaled down but should indicate the issue, I have tried all sorts of methods but it is very time consuming, my source includes some 200 element column headings and 7500 UPRN's per sheet, and i have about 5 sheets to process.
I would be really really grateful for any advice on what feature excel has that might be able to assist me in this.
Thank you