Combining rows by row position

[joseph_m_shopp]

I have 1500+  rows within the data there are 3 types of data Set_1, Set_2 and Set_3. I want to combine the 1st 4 rows of Set_1 data, There is no connection between the data on the rows. The data will populate into another form that allows up to 4 columns of data.Since the size of the data varies and there will be anywhere from 15 to 3000 rows it needs to allow for variable size. 

Set_1	What I have	Set_1-1		Set_1-1	Set_1-1	Set_1-1	Set_1-1
Set_1		Set_1-1	→→→	Set_1-2	Set_1-2	Set_1-2	Set_1-2
Set_1		Set_1-1		Set_1-3	Set_1-3	Set_1-3	Set_1-3
Set_1		Set_1-1		This is the outcome I want
Set_1		Set_1-2
Set_1	→→→	Set_1-2
Set_1		Set_1-2
Set_1		Set_1-2
Set_1		Set_1-3
Set_1		Set_1-3
Set_1		Set_1-3
Set_1		Set_1-3

[DiganP]

@joseph_m_shopp Have you tried using the summarize tool? You can use the groupby function.

[benakesh · Accepted solution]

Hi @joseph_m_shopp ,

Let me know if  make columns  has desired output .   

[joseph_m_shopp]

That did not work for me. I tried it both horizontally and vertically.
Thank You,

Joseph Shopp
Valuation Field Team, Texas, Louisiana, Mississippi, Alabama
Fannie Mae
714-713-0788 (direct) 240-699-5131 (fax)
joseph_m_shopp@fanniemae.com

This e-mail and its attachments are confidential and solely for the intended addressee(s). Do not share or use them without Fannie Mae's approval. If received in error, delete the message and contact the sender.

Help Prevent Fraud: If you are aware of or suspect inappropriate activity in connection with a Fannie Mae property, please immediately report it either by e-mail to Mortgagefraud_tips@fanniemae.com or to our Fraud Tips Hotline, 1-800-7FANNIE (1-800-732-6643).

[joseph_m_shopp]

It has the desired output. Better then what I was thinking.

[joesofine10]

magnificent!  Thank you!