Hi,
I have Excel sheets containing financial data in the form:
AccountDesc|Jan 1|Jan2|Jan 3 .......
Salaries|value1|value3|value5 .......
Bonuses|value2|value4|value6 .......
.......
I need to bring it to the form:
Date|AccountDesc|Value
Jan1|Salaries|value1
Jan1|Bonuses|value2
.......
Jan3|Salaries|value5
.......
Your assistance is much appreciated.
Thanks
Polar
I have Excel sheets containing financial data in the form:
AccountDesc|Jan 1|Jan2|Jan 3 .......
Salaries|value1|value3|value5 .......
Bonuses|value2|value4|value6 .......
.......
I need to bring it to the form:
Date|AccountDesc|Value
Jan1|Salaries|value1
Jan1|Bonuses|value2
.......
Jan3|Salaries|value5
.......
Your assistance is much appreciated.
Thanks
Polar