PJSR
10-01-2007, 01:35 AM
Hi,
The best way to describe what I need to do will be by using an example:
Currently I have information that reflects suburb detail and then the number of clients we have in each of those suburbs. I need to reflect the information only on suburb level for the charting software we use.
The current format of the data:
Suburb Number of clients
Centurion 5
Alberton 6
I need to change it to look like this:
Suburb
Centurion
Centurion
Centurion
Centurion
Centurion
Alberton
Alberton
Alberton
Alberton
Alberton
Alberton
I am currently using copy, paste and insert rows to do this but it's going to take me days to do this as we have 1000's to do.
Is there an easier way of achieving this? I include a sheet reflecting an example of the current format.
Thanks
The best way to describe what I need to do will be by using an example:
Currently I have information that reflects suburb detail and then the number of clients we have in each of those suburbs. I need to reflect the information only on suburb level for the charting software we use.
The current format of the data:
Suburb Number of clients
Centurion 5
Alberton 6
I need to change it to look like this:
Suburb
Centurion
Centurion
Centurion
Centurion
Centurion
Alberton
Alberton
Alberton
Alberton
Alberton
Alberton
I am currently using copy, paste and insert rows to do this but it's going to take me days to do this as we have 1000's to do.
Is there an easier way of achieving this? I include a sheet reflecting an example of the current format.
Thanks