Help needed! Automated grouping and re-ordering

[un_RRL]

Hi all, any help is appreciated

Basically I would like to get a large amount records from this format (example) -

[TABLE="width: 179"]
<tbody>[TR]
[TD]Names[/TD]
[TD]Addresses[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]xxx1[/TD]
[/TR]
[TR]
[TD]RR[/TD]
[TD]xxx1[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]xxx1[/TD]
[/TR]
[TR]
[TD]DD[/TD]
[TD]xxx1[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]xxx2[/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD]xxx2[/TD]
[/TR]
[TR]
[TD]GG[/TD]
[TD]xxx3[/TD]
[/TR]
[TR]
[TD]HH[/TD]
[TD]xxx3[/TD]
[/TR]
[TR]
[TD]KK[/TD]
[TD]xxx3[/TD]
[/TR]
[TR]
[TD]JJ[/TD]
[TD]xxx4[/TD]
[/TR]
</tbody>[/TABLE]

To this -

[TABLE="width: 519, align: left"]
<tbody>[TR]
[TD]Name 1[/TD]
[TD]Name 2[/TD]
[TD]Name 3[/TD]
[TD]Name 4[/TD]
[TD]Address[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]RR[/TD]
[TD]CC[/TD]
[TD]DD[/TD]
[TD]xxx1[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD]FF[/TD]
[TD][/TD]
[TD][/TD]
[TD]xxx2[/TD]
[/TR]
[TR]
[TD]GG[/TD]
[TD]HH[/TD]
[TD]KK[/TD]
[TD][/TD]
[TD]xxx3[/TD]
[/TR]
[TR]
[TD]JJ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]xxx4[/TD]
[/TR]
</tbody>[/TABLE]








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!

 

[alansidman]

crosspost: Help needed! Automated grouping and re-ordering

 

[un_RRL]

crosspost: Help needed! Automated grouping and re-ordering

Apologies and thank you for the link!