Traceelewis71
New Member
- Joined
- Dec 5, 2017
- Messages
- 12
I currently have a report of 8000 plus employees who have 12 rows of data each. each row of data has 3 columns that are represented for each month of the year. This is how my current reporting feature creates the report. the software I need to upload this data into is in the format below this chart.
<tbody>
</tbody>
I need this data to now be in this format
<tbody>
</tbody>
I am currently keying the data as I can't figure out a formula to get this data converted. This will take me weeks to do and leaves too much room for error. I've tried an index match formula but that's not working. I don't even know where to begin. Should I use access or SQL. I don't think SumIF formula will work because I don't want the employees' data totaled up.
<tbody> </tbody> |
<tbody>
</tbody>
I need this data to now be in this format
<tbody> </tbody> |
<tbody>
</tbody>
I am currently keying the data as I can't figure out a formula to get this data converted. This will take me weeks to do and leaves too much room for error. I've tried an index match formula but that's not working. I don't even know where to begin. Should I use access or SQL. I don't think SumIF formula will work because I don't want the employees' data totaled up.