Userlist - combining multiple columns

I have a userlist where I would like to filter by teacher's name, and Display the student's name (first and last), parent's name, and contact info (email, address, phone). My cb table has columns for EACH student. So, currently I am only able to display student 1 info.

Example:
Jane Doe has 3 students. The columns I am trying to unionall into one column: cb_student 1 first name, cb_student 2 first name, cb_student 3 first name. Then: cb_student 1 last name, cb_student 2 last name, and cb_student 3 last name.

So, all 3 students info would be displayed:

Teacher	Student Name	Parent Name	Contact Info
Ms. Smith	Doe, Julie	Doe, Jane	123 St.
Ms. Miller	Doe, Joey	Doe, Jane	123 St.
Mr. Casey	Doe, Sally	Doe, Jane	123 St.

Any ideas how to accomplish this? Is this possible within the cb?

If they're fields stored to the teachers profile you can use a Custom HTML field and substitutions as shown below.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

If it's stored in a custom database table then you can use CB Query Field to query for that information.

All of the info is stored in comprofiler (captured during registration).

I'm confused though on how I could show this list...each registrant (a parent) registers all of the data for each of their students. So student 1, student 2, student 3 and student 4 are all listed in one row of the table.

Another parent then registers all of their students (in the next row of the table).

I need to display this data in the userlist by teacher and then by student (but all student info needs to be listed in one column on the frontend userlist).

So each student and teacher are users within CB? As in they have their own account that you can manage in CB > User Management? Only way for the teachers to have a list of students on their profile as a field in that case is to query for them using CB Query Field aside from that I don't understand your situation, sorry.

Sorry I may not be explaining properly. The userlist on the frontend is available to all members. It is a menu item. Members can then access the member list.

This frontend member list needs to contain fields that are in cb table. The problem is that I need to display 4 columns of the table into 1 column on the frontend user list. I have four columns for students (cb_student 1, cb_student 2, etc), and then I have four column for teacher (cb_student 1 teacher, etc)

Does this help explain?

You have complete control over how many columns you have and what is in them so I don't understand the issue. You should be able to click the Add Rows button to add more fields to a column or add more columns. Example as follows.