Transpose Macro for single line consolidation

Hi

So you would have to determine the ID with the most account numbers, and create headings to cover that number, then fill for all the others at the appropriate place?

rylo