gracemcth
New Member
- Joined
- Aug 12, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Any advice would be GREATLY APPRECIATED!!
I'm struggling to figure out a way to re-organize the data from a generated report into a more usable format. I have been able to get the data from the generated report to look like it does in the "before" columns, but I still need it to be shifted up [to the top row of each order] and transformed [the 3 amounts in the consult cost column transformed into the Consult Cost/Labor Cost/Material Cost columns] into how it looks in the "after" columns. This would be for a sheet with thousands of orders each with a varying number of rows.
THANK YOU AGAIN!!!
e
I'm struggling to figure out a way to re-organize the data from a generated report into a more usable format. I have been able to get the data from the generated report to look like it does in the "before" columns, but I still need it to be shifted up [to the top row of each order] and transformed [the 3 amounts in the consult cost column transformed into the Consult Cost/Labor Cost/Material Cost columns] into how it looks in the "after" columns. This would be for a sheet with thousands of orders each with a varying number of rows.
THANK YOU AGAIN!!!