Hi All,
I'm a little stumped on how to format some data coming out of an accounting report. The report contains a column of social security numbers and separate columns for a number of benefits for which each employee may have deductions.
I would like format this data such that for each nonzero amount in any of the benefit columns I create a separate row including the benefit name, ssn, and benefit deduction amount.
Can you point me in the right direction?
Thanks!
-jay
Unknown
<tbody>
</tbody>
<tbody>
</tbody>
Unknown
<tbody>
</tbody>
<tbody>
</tbody>
I'm a little stumped on how to format some data coming out of an accounting report. The report contains a column of social security numbers and separate columns for a number of benefits for which each employee may have deductions.
I would like format this data such that for each nonzero amount in any of the benefit columns I create a separate row including the benefit name, ssn, and benefit deduction amount.
Can you point me in the right direction?
Thanks!
-jay
Unknown
Row\Col | A | B | C | D |
---|---|---|---|---|
1 | Social | Benefit 1 | Benefit 2 | Benefit 3 |
2 | 111-11-1111 | 270.84 | 0 | 0 |
3 | 222-22-2222 | 0 | 0 | 0 |
4 | 333-33-3333 | 37.5 | 1 | 22.75 |
5 | 444-44-4444 | 20.83 | 1 | 0 |
6 | 555-55-5555 | 62.5 | 1 | 39.15 |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
Unknown
Row\Col | A | B | C |
---|---|---|---|
1 | Benefit 1 | 111-11-1111 | 270.84 |
2 | Benefit 1 | 333-33-3333 | 37.5 |
3 | Benefit 2 | 333-33-3333 | 1 |
4 | Benefit 3 | 333-33-3333 | 22.75 |
5 | Benefit 1 | 444-44-4444 | 20.83 |
6 | Benefit 2 | 444-44-4444 | 1 |
7 | Benefit 1 | 555-55-5555 | 62.5 |
8 | Benefit 2 | 555-55-5555 | 1 |
9 | Benefit 3 | 555-55-5555 | 39.15 |
<tbody>
</tbody>
Sheet: Sheet2 |
<tbody>
</tbody>