Repeating Column Headers into Rows

[nlafountain]

Hello All,

I have a data set that contains multiple repeating headers of First Name, Last Name, Email, Relationship that repeats over several columns. I want to take this data and combine them all into 4 total columns with multiple rows. So I would end up with a list of First Name, Last Name, Email, Relationship populating all the rows beneath the data from the multiple columns. Thank you in advance for your assistance!

 

[Toadstool]

Hi NLAFountain,

This should do what you ask but I've a sneaking suspicion you've more than one row of data and you'd like the rows you generate to stack below. For that I'd need a helper column.

NLAFountain.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	First Name	Last Name	Email	Relationship to Player	First Name	Last Name	Email	Relationship to Player	First Name	Last Name	Email	Relationship to Player	First Name	Last Name	Email	Relationship to Player
2	Sam1	Last2	Last2@mail.com	Friend4	Sam5	Last6	Last6@mail.com	Friend8	Sam9	Last10	Last10@mail.com	Friend12	Sam13	Last14	Last14@mail.com	Friend16
3
4
5	First Name	Last Name	Email	Relationship to Player
6	Sam1	Last2	Last2@mail.com	Friend4
7	Sam5	Last6	Last6@mail.com	Friend8
8	Sam9	Last10	Last10@mail.com	Friend12
9	Sam13	Last14	Last14@mail.com	Friend16
1st (2)

Cell Formulas
Range	Formula
A6:D9	A6	=INDEX($A$2:$ZZ$2,,(((ROW()-ROW($A$5)-1)*4))+COLUMN())&""

 

[nlafountain]

Thank you so much! I will give this a try!