Re: Creating dynamic variable names & aggregating

In your desired output, before aggregation, you have Address2 2016 Account2

but there is no such combination in your input data. How can this be?

Why do you need columns? Why isn't the original layout where there is one record on a row sufficient? What are you going to do next that these columns are needed? They are not needed for aggregating by Address.