Hi, Is it possible to change data format in Excel. My data in excel is as follows:
Name of GL GL Code Jan-19 Feb-19 Mar-19 Apr-19......until Dec-19
Salaries 8205 $100 $200 $300 $400 $1200[/PHP][/HTML]
Tax 8206 $10 $20 $30 $40 $120
I need to show it as follows:
Salaries 8205 Jan-19 $100
Salaries 8205 Feb-19 $200
Salaries 8205 Mar-19 $300
Salaries 8205 Apr-19 $400
all twelve months going down for every GL Code as there are hundreds of different GL codes
then new GL 8206 straight after GL 8205 in a continuous rows of data
Tax 8206 Jan-19 $10
Tax 8206 Feb-19 $200
Tax 8206 Mar-19 $300
Tax 8206 Apr-19 $400
Your help would be greatly appreciated as this will save me hours of work.
Many thanks in advance
Name of GL GL Code Jan-19 Feb-19 Mar-19 Apr-19......until Dec-19
Salaries 8205 $100 $200 $300 $400 $1200[/PHP][/HTML]
Tax 8206 $10 $20 $30 $40 $120
I need to show it as follows:
Salaries 8205 Jan-19 $100
Salaries 8205 Feb-19 $200
Salaries 8205 Mar-19 $300
Salaries 8205 Apr-19 $400
all twelve months going down for every GL Code as there are hundreds of different GL codes
then new GL 8206 straight after GL 8205 in a continuous rows of data
Tax 8206 Jan-19 $10
Tax 8206 Feb-19 $200
Tax 8206 Mar-19 $300
Tax 8206 Apr-19 $400
Your help would be greatly appreciated as this will save me hours of work.
Many thanks in advance