Vertical to Horizontal

[Brown]

Thanks in advance for your assistance.

How can I take this information and make it so the information reads Horizontally? I need one row and each of the items in column G to be in a separate column like the second screen shot.

 

[alansidman]

One option available is to pivot your data with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Student ID"}, {{"Data", each _, type table [First Name=text, Last Name=text, Student ID=number, Gender=text, Grade Lev=number, #" Homeroom Teacher "=text, SPRING SEMESTER PLACEMENT=text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data],"Index",1,1)),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"First Name", "Last Name", "Student ID", "Gender", "Grade Lev", " Homeroom Teacher ", "SPRING SEMESTER PLACEMENT", "Index"}, {"First Name", "Last Name", "Student ID", "Gender", "Grade Lev", " Homeroom Teacher ", "SPRING SEMESTER PLACEMENT", "Index"}),
    #"Added Prefix" = Table.TransformColumns(#"Expanded Custom", {{"Index", each "Course " & Text.From(_, "en-US"), type text}}),
    #"Pivoted Column" = Table.Pivot(#"Added Prefix", List.Distinct(#"Added Prefix"[Index]), "Index", "SPRING SEMESTER PLACEMENT")
in
    #"Pivoted Column"

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	First Name	Last Name	Student ID	Gender	Grade Lev	Homeroom Teacher	SPRING SEMESTER PLACEMENT
2	Bill	Smith	1260540	M	9	Jane Doe	Algebra B
3	Bill	Smith	1260540	M	9	Jane Doe	Biology B
4	Bill	Smith	1260540	M	9	Jane Doe	French 1 B
5	Bill	Smith	1260540	M	9	Jane Doe	PLTW Introduction to Engineering Design B
6	Bill	Smith	1260540	M	9	Jane Doe	World Geography B
7
8	First Name	Last Name	Student ID	Gender	Grade Lev	Homeroom Teacher	Course 1	Course 2	Course 3	Course 4	Course 5
9	Bill	Smith	1260540	M	9	Jane Doe	Algebra B	Biology B	French 1 B	PLTW Introduction to Engineering Design B	World Geography B
Sheet1

 

[Brown]

One option available is to pivot your data with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Student ID"}, {{"Data", each _, type table [First Name=text, Last Name=text, Student ID=number, Gender=text, Grade Lev=number, #" Homeroom Teacher "=text, SPRING SEMESTER PLACEMENT=text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data],"Index",1,1)),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"First Name", "Last Name", "Student ID", "Gender", "Grade Lev", " Homeroom Teacher ", "SPRING SEMESTER PLACEMENT", "Index"}, {"First Name", "Last Name", "Student ID", "Gender", "Grade Lev", " Homeroom Teacher ", "SPRING SEMESTER PLACEMENT", "Index"}),
    #"Added Prefix" = Table.TransformColumns(#"Expanded Custom", {{"Index", each "Course " & Text.From(_, "en-US"), type text}}),
    #"Pivoted Column" = Table.Pivot(#"Added Prefix", List.Distinct(#"Added Prefix"[Index]), "Index", "SPRING SEMESTER PLACEMENT")
in
    #"Pivoted Column"

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	First Name	Last Name	Student ID	Gender	Grade Lev	Homeroom Teacher	SPRING SEMESTER PLACEMENT
2	Bill	Smith	1260540	M	9	Jane Doe	Algebra B
3	Bill	Smith	1260540	M	9	Jane Doe	Biology B
4	Bill	Smith	1260540	M	9	Jane Doe	French 1 B
5	Bill	Smith	1260540	M	9	Jane Doe	PLTW Introduction to Engineering Design B
6	Bill	Smith	1260540	M	9	Jane Doe	World Geography B
7
8	First Name	Last Name	Student ID	Gender	Grade Lev	Homeroom Teacher	Course 1	Course 2	Course 3	Course 4	Course 5
9	Bill	Smith	1260540	M	9	Jane Doe	Algebra B	Biology B	French 1 B	PLTW Introduction to Engineering Design B	World Geography B
Sheet1

Thank you for the help. I will give this a try and see if I can make it work.
I appreciate the assist.

 

[Fluff]

A formula option

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	First Name	Last Name	Student ID	Gender	Grade Lev	Homeroom Teacher	SPRING SEMESTER PLACEMENT
2	Bill	Smith	1260540	M	9	Jane Doe	Algebra B				Bill	Smith	1260540	M	9	Jane Doe	Algebra B	Biology B	French 1 B
3	Bill	Smith	1260540	M	9	Jane Doe	Biology B				Anne	Smith	1260541	F	9	Jane Doe	PLTW Introduction to Engineering Design B	World Geography B
4	Bill	Smith	1260540	M	9	Jane Doe	French 1 B
5	Anne	Smith	1260541	F	9	Jane Doe	PLTW Introduction to Engineering Design B
6	Anne	Smith	1260541	F	9	Jane Doe	World Geography B
Sheet6

Cell Formulas
Range	Formula
K2:S3	K2	=LET(u,UNIQUE(FILTER(C2:C100,C2:C100<>"")),m,MAX(COUNTIFS(C:C,u)),DROP(REDUCE("",u,LAMBDA(x,y,VSTACK(x,HSTACK(TAKE(FILTER(A2:F100,C2:C100=y),1),EXPAND(TOROW(FILTER(G2:G100,C2:C100=y)),,m,""))))),1))
Dynamic array formulas.