Hi all, any help is appreciated
Basically I would like to get a large amount records from this format (example) -
Names Addresses AA xxx1 RR xxx1 CC xxx1 DD xxx1 EE xxx2 FF xxx2 GG xxx3 HH xxx3 KK xxx3 JJ xxx4
To this -
Name 1 Name 2 Name 3 Name 4 Address AA RR CC DD xxx1 EE FF xxx2 GG HH KK xxx3 JJ xxx4
Essentially grouping individuals by addresses in common and re-ordering the names into columns.
There could be more than 4 names per addresses in common so more columns would be needed as required.
I’ve experimented with Pivot tables and the Transpose function but no luck so far. Pivot tables produce something close to what I would like, but I was not able to automate the name reorganization into columns process, and the resulting spreadsheet needs to be in a plain format.
I've tried to delve into VBA to solve this but I need to learn a lot more before I can make a meaningful attempt at coding a solution to this on my own.
Thanks in advance!
Edit - Cross-post: http://www.mrexcel.com/forum/excel-q...-ordering.html
Bookmarks