I've been searching this forum to see if I could find a suitable solution, but haven't found a proper one yet, so here we go.
My table looks like this:
[TABLE="width: 700"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name 1[/TD]
[TD]Address 1[/TD]
[TD]Place 1[/TD]
[TD]Name 2[/TD]
[TD]Address 2[/TD]
[TD]Place 2[/TD]
[TD]Name 3[/TD]
[TD]Adress 3[/TD]
[TD]Place 3[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]AA[/TD]
[TD]ZZ[/TD]
[TD]11[/TD]
[TD]BB[/TD]
[TD]YY[/TD]
[TD]22[/TD]
[TD]CC[/TD]
[TD]XX[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]354[/TD]
[TD]DD[/TD]
[TD]WW[/TD]
[TD]44[/TD]
[TD]EE[/TD]
[TD]VV[/TD]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]FF[/TD]
[TD]UU[/TD]
[TD]66[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]GG[/TD]
[TD]TT[/TD]
[TD]77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]HH[/TD]
[TD]SS[/TD]
[TD]88[/TD]
[TD]II[/TD]
[TD]RR[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]358[/TD]
[TD]JJ[/TD]
[TD]QQ[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]KK[/TD]
[TD]PP[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Note that there are about 90 possible columns that might be used by a certain row (so, up to column "Place 30"). Also note that there is no logic in Name, Address, or Place cell values (in contrast to the above example).
I'd like to use a macro that transposes each three following columns (Name, Address, Place) to a separate row as follows:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Address[/TD]
[TD]Place[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]AA[/TD]
[TD]ZZ[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]BB[/TD]
[TD]YY[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]CC[/TD]
[TD]XX[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]354[/TD]
[TD]DD[/TD]
[TD]WW[/TD]
[TD]44[/TD]
[/TR]
[TR]
[TD]354[/TD]
[TD]EE[/TD]
[TD]VV[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]FF[/TD]
[TD]UU[/TD]
[TD]66[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]GG[/TD]
[TD]TT[/TD]
[TD]77[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]HH[/TD]
[TD]SS[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]II[/TD]
[TD]RR[/TD]
[TD]99[/TD]
[/TR]
[TR]
[TD]358[/TD]
[TD]JJ[/TD]
[TD]QQ[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]KK[/TD]
[TD]PP[/TD]
[TD]11[/TD]
[/TR]
</tbody>[/TABLE]
Any suggestions to get to the above result?
Thanks,
Ruben
My table looks like this:
[TABLE="width: 700"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name 1[/TD]
[TD]Address 1[/TD]
[TD]Place 1[/TD]
[TD]Name 2[/TD]
[TD]Address 2[/TD]
[TD]Place 2[/TD]
[TD]Name 3[/TD]
[TD]Adress 3[/TD]
[TD]Place 3[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]AA[/TD]
[TD]ZZ[/TD]
[TD]11[/TD]
[TD]BB[/TD]
[TD]YY[/TD]
[TD]22[/TD]
[TD]CC[/TD]
[TD]XX[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]354[/TD]
[TD]DD[/TD]
[TD]WW[/TD]
[TD]44[/TD]
[TD]EE[/TD]
[TD]VV[/TD]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]FF[/TD]
[TD]UU[/TD]
[TD]66[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]GG[/TD]
[TD]TT[/TD]
[TD]77[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]HH[/TD]
[TD]SS[/TD]
[TD]88[/TD]
[TD]II[/TD]
[TD]RR[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]358[/TD]
[TD]JJ[/TD]
[TD]QQ[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]KK[/TD]
[TD]PP[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Note that there are about 90 possible columns that might be used by a certain row (so, up to column "Place 30"). Also note that there is no logic in Name, Address, or Place cell values (in contrast to the above example).
I'd like to use a macro that transposes each three following columns (Name, Address, Place) to a separate row as follows:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Name[/TD]
[TD]Address[/TD]
[TD]Place[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]AA[/TD]
[TD]ZZ[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]BB[/TD]
[TD]YY[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]CC[/TD]
[TD]XX[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]354[/TD]
[TD]DD[/TD]
[TD]WW[/TD]
[TD]44[/TD]
[/TR]
[TR]
[TD]354[/TD]
[TD]EE[/TD]
[TD]VV[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]FF[/TD]
[TD]UU[/TD]
[TD]66[/TD]
[/TR]
[TR]
[TD]212[/TD]
[TD]GG[/TD]
[TD]TT[/TD]
[TD]77[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]HH[/TD]
[TD]SS[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]II[/TD]
[TD]RR[/TD]
[TD]99[/TD]
[/TR]
[TR]
[TD]358[/TD]
[TD]JJ[/TD]
[TD]QQ[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]109[/TD]
[TD]KK[/TD]
[TD]PP[/TD]
[TD]11[/TD]
[/TR]
</tbody>[/TABLE]
Any suggestions to get to the above result?
Thanks,
Ruben