They have an excel spreadsheet with cost centers, expense codes, values and descriptions on (See example attachment) As you can see from the attachment, the Cost Centres and Expense Codes are seperated out into FROM and TO columns.
I need to make these a single column for each.
So for example..
Instead of it being
Cost Center Expense Code
FROM TO FROM TO
101 101 800 801
101 101 802 899
102 103 900 950
I need it to be..
Cost Center Expense Codes
101 800
101 801
101 802
101 803 (DOWN TO 899)
101 899
102 900
102 901 ETC
Can anyone tell me if there is an easy way to do this please.
