user028686 Member

That worked, thank you!

Thank you! I am getting closer...the first two rows are displaying correctly now, but now Account B is also being replaced with the name field, so how do I prevent that from happening?

Thank you. That does not seem to give me the correct result because if column 2 is blank, then it is showing blank in the new column.

Thank you for your response. This worked to show 2 weeks prior but when I do that to only show the previous week, it just displays the total for 2020 data, not 2021. The previous week is 12/27/20 - 1/2/21.