I have used Power Query which should be part of your Excel 2013 version. I loaded your "table" to PQ. Added a column for each of the GL accounts and inserted the values as pluses and minus.
I then removed the original value column and then unpivoted the data.
Here is the Mcode for that exercise.
v |
A |
B |
C |
1 |
Column1 |
Attribute |
Value |
2 |
Cat |
170040 |
10 |
3 |
Cat |
544110 |
-10 |
4 |
Dog |
170040 |
15 |
5 |
Dog |
544110 |
-15 |
6 |
Cow |
170040 |
12 |
7 |
Cow |
544110 |
-12 |
File attached.
Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps
Bookmarks