Hi,
I have a large volume of data in multiple rows & columns that needs convering into 3 columns (approximately 9,000 rows by 30 columns). Here is a sample of the original data & the converted version I need to get to:
**Original data:**
Ref Cleaning Maintenance
1234 0.06 0.11
1235 0.07 0.12
1236 0.08 0.13
1237 0.09 0.14
1238 0.1 0.15
**Converted data:**
Ref Service Charge
1234 Cleaning 0.06
1234 Maintenance 0.11
1235 Cleaning 0.07
1235 Maintenance 0.12
1236 Cleaning 0.08
1236 Maintenance 0.13
1237 Cleaning 0.09
1237 Maintenance 0.14
1238 Cleaning 0.10
1238 Maintenance 0.15
I have researched possibilites using VBA & found a few answers that do part of what I need. However, I do not understand the script well enough to amend it. In addition given the size of data I need to convert, can anything be done to speed it up?
Any help would be greatly appreciated.
Thanks
Bookmarks