Hello,
This is what my file looks like:
<tbody>
</tbody>
What I want to do is drag Columns B, C, D, and H (Inv#, Dept, Vendor Ref#, and Inv Amt) such that I can drag-down the same value until I reach the next value and then duplicate that value down. I would like to automate that process, since I'm dealing with tens of thousands of rows.
So, if I did that with Column B, for example, it would now look like this:
<tbody>
</tbody>
As noted, this will be done for tens of thousands of rows. If I were to do it manually, it would take lots of time and the potential for error is high.
There are multiple points were the value changes in a column and a new value needs to be dragged down until the next value. Columns "check#", "payment date", and "manager name" already have been duplicated.
Are there any shortcuts for doing this?
Let me know if I need to clarify anything.
Thanks!
This is what my file looks like:
Date | Inv# | Dept | Vendor Ref# | Check# | Payment Date | Amt Paid | Inv Amt | Manager Name |
11/01/2014 | 300699 | IT | COOL33 | 11111 | 11/10/2014 | $2,000.00 | $2,528.00 | SMITH BILL |
11111 | 11/10/2014 | $500.00 | SMITH BILL | |||||
11111 | 11/10/2014 | $20.00 | SMITH BILL | |||||
11111 | 11/10/2014 | $5.00 | SMITH BILL | |||||
11111 | 11/10/2014 | $3.00 | SMITH BILL | |||||
355999 | HR | AIR44 | 22222 | 11/10/2014 | $600.00 | $1,025.00 | ATKINS WADE | |
22222 | 11/10/2014 | $300.00 | ATKINS WADE | |||||
22222 | 11/10/2014 | $100.00 | ATKINS WADE | |||||
22222 | 11/10/2014 | $20.00 | ATKINS WADE | |||||
22222 | 11/10/2014 | $5.00 | ATKINS WADE |
<tbody>
</tbody>
What I want to do is drag Columns B, C, D, and H (Inv#, Dept, Vendor Ref#, and Inv Amt) such that I can drag-down the same value until I reach the next value and then duplicate that value down. I would like to automate that process, since I'm dealing with tens of thousands of rows.
So, if I did that with Column B, for example, it would now look like this:
Date | Inv# | Dept | Vendor Ref# | Check# | Payment Date | Amt Paid | Inv Amt | Manager Name |
11/01/2014 | 300699 | IT | COOL33 | 11111 | 11/10/2014 | $2,000.00 | $2,528.00 | SMITH BILL |
300699 | 11111 | 11/10/2014 | $500.00 | SMITH BILL | ||||
300699 | 11111 | 11/10/2014 | $20.00 | SMITH BILL | ||||
300699 | 11111 | 11/10/2014 | $5.00 | SMITH BILL | ||||
300699 | 11111 | 11/10/2014 | $3.00 | SMITH BILL | ||||
355999 | HR | AIR44 | 22222 | 11/10/2014 | $600.00 | $1,025.00 | ATKINS WADE | |
355999 | 22222 | 11/10/2014 | $300.00 | ATKINS WADE | ||||
355999 | 22222 | 11/10/2014 | $100.00 | ATKINS WADE | ||||
355999 | 22222 | 11/10/2014 | $20.00 | ATKINS WADE | ||||
355999 | 22222 | 11/10/2014 | $5.00 | ATKINS WADE |
<tbody>
</tbody>
As noted, this will be done for tens of thousands of rows. If I were to do it manually, it would take lots of time and the potential for error is high.
There are multiple points were the value changes in a column and a new value needs to be dragged down until the next value. Columns "check#", "payment date", and "manager name" already have been duplicated.
Are there any shortcuts for doing this?
Let me know if I need to clarify anything.
Thanks!