I think this is simple, vertical information to horizontal..

[bushidowarrior]

Hello, from the image located below I would like to convert all of the vertical information into horizontal information. I know that you can use transpose but I have a problem here.


I need this to be formula based to some degree. In other words, the horizontal information at the bottom, the last, first and ID is displayed based on the actual group ID.


So I'm not quite sure how I would go about doing this.

Thank you

 

[Peter_SSs]

Could you provide that sample data in a form we can copy to test? My signature block below has a link with suggestion for doing so.
Most helpers won't want to have to type all that out.

 

[bushidowarrior]

Of course!!!

I have uploaded it to an FTP: http://i3tek.com/temp/test123.xlsx

I will try to provide some more information.


Effectively, on the bottom horizontal columns. If I change the group ID, for example the first row, I change it to group 3, all the corresponding last names, first names and ID will change in accordance to the information located in the top vertical table.

Thank you very much!

 

[Peter_SSs]

Thanks for the sample data. First & Last names look a bit odd though!

Try this
Formula in A18 is copied down as far as you might need.
Formula in B18 is copied across and down.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Last Name	First Name	ID	GROUP ID
2	Alina	Morrison	9497	GROUP 1
3	Freddie	Cole	2966	GROUP 1
4	Frederick	Scott	3920	GROUP 1
5	Elian	Fowler	4603	GROUP 2
6	Eddy	Watson	5475	GROUP 2
7	Catherine	Watson	7145	GROUP 2
8	Lilianna	Howard	4297	GROUP 3
9	Emma	Clark	7177	GROUP 3
10	Amanda	Fowler	1212	GROUP 3
11	Caroline	Parker	7981	GROUP 4
12	Martin	Anderson	2604	GROUP 4
13	Clark	Anderson	2605	GROUP 4
14
15
16
17	GROUP ID	Last Name	First Name	ID	Last Name	First Name	ID	Last Name	First Name	ID
18	GROUP 1	Alina	Morrison	9497	Freddie	Cole	2966	Frederick	Scott	3920
19	GROUP 2	Elian	Fowler	4603	Eddy	Watson	5475	Catherine	Watson	7145
20	GROUP 3	Lilianna	Howard	4297	Emma	Clark	7177	Amanda	Fowler	1212
21	GROUP 4	Caroline	Parker	7981	Martin	Anderson	2604	Clark	Anderson	2605
22
TEST SYSTEM (2)

 

[bushidowarrior]

Thanks for the sample data. First & Last names look a bit odd though!

Try this
Formula in A18 is copied down as far as you might need.
Formula in B18 is copied across and down.

TEST SYSTEM (2)

	A	B	C	D	E	F	G	H	I	J

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:130px;"><col style="width:133px;"><col style="width:117px;"><col style="width:110px;"><col style="width:114px;"><col style="width:117px;"><col style="width:49px;"><col style="width:114px;"><col style="width:117px;"><col style="width:49px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: left"]Last Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: left"]First Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]ID[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: left"]GROUP ID[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Alina[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Morrison[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: left"]9497[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]GROUP 1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Freddie[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Cole[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: left"]2966[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]GROUP 1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Frederick[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Scott[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: left"]3920[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]GROUP 1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]Elian[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]Fowler[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] , align: left"]4603[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]GROUP 2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]Eddy[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]Watson[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] , align: left"]5475[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]GROUP 2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]Catherine[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]Watson[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] , align: left"]7145[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc99]#ffcc99[/URL] "]GROUP 2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]Lilianna[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]Howard[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] , align: left"]4297[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]GROUP 3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]Emma[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]Clark[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] , align: left"]7177[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]GROUP 3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]Amanda[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]Fowler[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] , align: left"]1212[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=9999ff]#9999ff[/URL] "]GROUP 3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Caroline[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Parker[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: left"]7981[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]GROUP 4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Martin[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Anderson[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: left"]2604[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]GROUP 4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Clark[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]Anderson[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: left"]2605[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] "]GROUP 4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]16[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: left"]GROUP ID[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: left"]Last Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: left"]First Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: left"]ID[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99ccff]#99ccff[/URL] , align: left"]Last Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99ccff]#99ccff[/URL] , align: left"]First Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99ccff]#99ccff[/URL] , align: left"]ID[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc00]#ffcc00[/URL] , align: left"]Last Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc00]#ffcc00[/URL] , align: left"]First Name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffcc00]#ffcc00[/URL] , align: left"]ID[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]18[/TD]
[TD="align: left"]GROUP 1[/TD]
[TD="align: left"]Alina[/TD]
[TD="align: left"]Morrison[/TD]
[TD="align: left"]9497[/TD]
[TD="align: left"]Freddie[/TD]
[TD="align: left"]Cole[/TD]
[TD="align: left"]2966[/TD]
[TD="align: left"]Frederick[/TD]
[TD="align: left"]Scott[/TD]
[TD="align: left"]3920[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]19[/TD]
[TD="align: left"]GROUP 2[/TD]
[TD="align: left"]Elian[/TD]
[TD="align: left"]Fowler[/TD]
[TD="align: left"]4603[/TD]
[TD="align: left"]Eddy[/TD]
[TD="align: left"]Watson[/TD]
[TD="align: left"]5475[/TD]
[TD="align: left"]Catherine[/TD]
[TD="align: left"]Watson[/TD]
[TD="align: left"]7145[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]20[/TD]
[TD="align: left"]GROUP 3[/TD]
[TD="align: left"]Lilianna[/TD]
[TD="align: left"]Howard[/TD]
[TD="align: left"]4297[/TD]
[TD="align: left"]Emma[/TD]
[TD="align: left"]Clark[/TD]
[TD="align: left"]7177[/TD]
[TD="align: left"]Amanda[/TD]
[TD="align: left"]Fowler[/TD]
[TD="align: left"]1212[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]21[/TD]
[TD="align: left"]GROUP 4[/TD]
[TD="align: left"]Caroline[/TD]
[TD="align: left"]Parker[/TD]
[TD="align: left"]7981[/TD]
[TD="align: left"]Martin[/TD]
[TD="align: left"]Anderson[/TD]
[TD="align: left"]2604[/TD]
[TD="align: left"]Clark[/TD]
[TD="align: left"]Anderson[/TD]
[TD="align: left"]2605[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]22[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula A18 =IFERROR(INDEX(D$2:D$13,AGGREGATE(15,6,(ROW(D$2:D$13)-ROW(D$2)+1)/(D$2:D$13<>D$1:D$12),ROWS(A$18:A18))),"") B18 =IFERROR(INDEX($A$2:$C$13,AGGREGATE(15,6,(ROW($A$2:$A$13)-ROW($A$2)+1)/($D$2:$D$13=$A18),COUNTIF($B$17:B$17,B$17)),MATCH(B$17,$A$1:$C$1,0)),"") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

And here I was thinking that it was something simple. Evidently for you it is ridiculously simple. Thank you ever so much, proof of concept seems to be working very well as I have added another group and it seems to work... I'm going to try to implement it in my proper Excel....I really wish I could buy you a beer or 10!!!! LOLOL thank you ever so much. I will keep you fully updated

 

[Peter_SSs]

And here I was thinking that it was something simple. Evidently for you it is ridiculously simple. Thank you ever so much, proof of concept seems to be working very well as I have added another group and it seems to work... I'm going to try to implement it in my proper Excel....
I will keep you fully updated

You're welcome. Yes, let us know if you encounter any problems.

I really wish I could buy you a beer or 10!!!!

Hmm, I'm feeling a little thirsty too.


BTW, best not to fully quote long posts as it makes the thread harder to read/navigate. If you want to quote, quote small, relevant parts only.

 

[sandy666]

another way is PowerQuery

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]1st way[/td][td=bgcolor:#4472C4]GROUP ID[/td][td=bgcolor:#4472C4]First Name[/td][td=bgcolor:#4472C4]Last Name[/td][td=bgcolor:#4472C4]ID[/td][td=bgcolor:#4472C4]First Name.1[/td][td=bgcolor:#4472C4]Last Name.1[/td][td=bgcolor:#4472C4]ID.1[/td][td=bgcolor:#4472C4]First Name.2[/td][td=bgcolor:#4472C4]Last Name.2[/td][td=bgcolor:#4472C4]ID.2[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td=bgcolor:#D9E1F2]GROUP 1[/td][td=bgcolor:#D9E1F2]Alina[/td][td=bgcolor:#D9E1F2]Morrison[/td][td=bgcolor:#D9E1F2]

9497​

[/td][td=bgcolor:#D9E1F2]Freddie[/td][td=bgcolor:#D9E1F2]Cole[/td][td=bgcolor:#D9E1F2]

2966​

[/td][td=bgcolor:#D9E1F2]Frederick[/td][td=bgcolor:#D9E1F2]Scott[/td][td=bgcolor:#D9E1F2]

3920​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td]GROUP 2[/td][td]Elian[/td][td]Fowler[/td][td]

4603​

[/td][td]Eddy[/td][td]Watson[/td][td]

5475​

[/td][td]Catherine[/td][td]Watson[/td][td]

7145​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td=bgcolor:#D9E1F2]GROUP 3[/td][td=bgcolor:#D9E1F2]Lilianna[/td][td=bgcolor:#D9E1F2]Howard[/td][td=bgcolor:#D9E1F2]

4297​

[/td][td=bgcolor:#D9E1F2]Emma[/td][td=bgcolor:#D9E1F2]Clark[/td][td=bgcolor:#D9E1F2]

7177​

[/td][td=bgcolor:#D9E1F2]Amanda[/td][td=bgcolor:#D9E1F2]Fowler[/td][td=bgcolor:#D9E1F2]

1212​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td]GROUP 4[/td][td]Caroline[/td][td]Parker[/td][td]

7981​

[/td][td]Martin[/td][td]Anderson[/td][td]

2604​

[/td][td]Clark[/td][td]Anderson[/td][td]

2605​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]2nd way[/td][td=bgcolor:#000000]GROUP ID[/td][td=bgcolor:#000000]Last Name.1[/td][td=bgcolor:#000000]First Name.1[/td][td=bgcolor:#000000]ID.1[/td][td=bgcolor:#000000]Last Name.2[/td][td=bgcolor:#000000]First Name.2[/td][td=bgcolor:#000000]ID.2[/td][td=bgcolor:#000000]Last Name.3[/td][td=bgcolor:#000000]First Name.3[/td][td=bgcolor:#000000]ID.3[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td=bgcolor:#D9D9D9]GROUP 1[/td][td=bgcolor:#D9D9D9]Alina[/td][td=bgcolor:#D9D9D9]Morrison[/td][td=bgcolor:#D9D9D9]

9497​

[/td][td=bgcolor:#D9D9D9]Freddie[/td][td=bgcolor:#D9D9D9]Cole[/td][td=bgcolor:#D9D9D9]

2966​

[/td][td=bgcolor:#D9D9D9]Frederick[/td][td=bgcolor:#D9D9D9]Scott[/td][td=bgcolor:#D9D9D9]

3920​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td]GROUP 2[/td][td]Elian[/td][td]Fowler[/td][td]

4603​

[/td][td]Eddy[/td][td]Watson[/td][td]

5475​

[/td][td]Catherine[/td][td]Watson[/td][td]

7145​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td=bgcolor:#D9D9D9]GROUP 3[/td][td=bgcolor:#D9D9D9]Lilianna[/td][td=bgcolor:#D9D9D9]Howard[/td][td=bgcolor:#D9D9D9]

4297​

[/td][td=bgcolor:#D9D9D9]Emma[/td][td=bgcolor:#D9D9D9]Clark[/td][td=bgcolor:#D9D9D9]

7177​

[/td][td=bgcolor:#D9D9D9]Amanda[/td][td=bgcolor:#D9D9D9]Fowler[/td][td=bgcolor:#D9D9D9]

1212​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td]GROUP 4[/td][td]Caroline[/td][td]Parker[/td][td]

7981​

[/td][td]Martin[/td][td]Anderson[/td][td]

2604​

[/td][td]Clark[/td][td]Anderson[/td][td]

2605​

[/td][/tr]
[/table]

example file