Transpose Rows to Columns

[gzell]

In the worksheet Column G is data Designation and Column H is data that goes with Column G. on each row. I need help in converting rows below row 1_12 for each individual soldier in column G to columns on new worksheet. The original rows have a Data_ID that corresponds with Data in Column G and H, not sure if this would help in the conversion.. Step one would include the rows with Data following Data_ID 1_12 (Column G) these would be moved to another worksheet and transposed to columns. Column H would then be moved to the new worksheet and the data entry would be placed on rows below the corresponding Column in step one.

Number of entries will be different for each soldier.

Worksheet has 1145 Soldiers and with 27486 rows of data.

Is this possible?

Original Worksheet

A B C D E F G H

Row_ID	Person_ID	Last Name​	First Name​	Middle​	Data_ID​	Research Data​
1
2	1	Able​	Ezekiel​		1_1​	Army​	Confederacy​
3	1				1_2​	Location​	Texas​
4	1				1_3​	Regiment​	10th Regiment Texas Infantry (Nelson's)​
5	1				1_4​	Function​	Infantry​
6	1				1_5​	Company​	C​
7	1				1_6​	Rank​	Private​
8	1				1_7​	Age​	--​
9	1				1_8​	Residence​	--​
10	1				1_9​	Enrolled​	Buchanan, Johnson County, Texas​
11	1				1_10​	Date​	October 16, 1861​
12	1				1_11​	Enlisted​	Houston, Texas​
13	1				1_12​	Date​	October 25, 1861​
14	1				2_1​	Detail​	Hospital Nurse​
15	1				2_1​	Detail​	November 8, 1862​
16	1				3_1​	Relieved of Duty​	Nurse​
17	1				3_1​	Date​	February 4, 1862​
18	1				4_1​	Captured​	Battle of Arkansas Post​
19	1				4_1​	Date​	January 11, 1863​
20	1				4_2​	Forwarded​	St. Louis, Missouri via Boats​
21	1				4_3​	Forwarded​	Camp Douglas, Illinois via Rail​
22	1				4_4​	Prisoner​	Camp Douglas, Illinois​
23	1				4_5​	Died​	March 7, 1863​
24	1				4_5​	Cause​	Small Pox​
25
26	2	Adams​	John​	H​	1_1​	Army​	Confederacy​
27	2				1_2​	Location​	Texas​
28	2				1_3​	Regiment​	10th Regiment Texas Infantry (Nelson's)​
29	2				1_4​	Function​	Infantry​
30	2				1_5​	Company​	I​
31	2				1_6​	Rank​	Corporal​
32	2				1_7​	Age​	42​
33	2				1_8​	Residence​	Johnson County, Texas​
34	2				1_9​	Enlisted​	Kimball Texas or Millican, Texas​
35	2				1_10​	Date​	January 16, 1862​
36	2				2_1​	Captured​	Battle Arkansas Post, Arkansas​
37	2				2_1​	Date​	January 11, 1863​
38	2				2_1​	Forwarded​	St. Louis, Missouri via Boats​
39	2				2_1​	Forwarded​	Camp Douglas, Illinois via Rail​
40	2				2_1​	Prisoner​	Camp Douglas, Illinois​
41	2				2_1​	Forwarded for Exchanged​	City Point, Virginia​
42	2				2_1​	Date​	April 10, 1863​
43	2				2_10​	Hospital​	Sick​
44	2				2_10​	Location​	Kingston, Georgia​
45	2				2_10​	Date​	March 22, 1864​
46	2				2_1​	Captured​	Franklin, Tennessee​
47	2				2_1​	Date​	November 30, 1864​
48	2				2_1​	Forwarded​	Nashville, Tennessee​
49	2				2_1​	Forwarded​	Louisville, Kentucky​
50	2				2_1​	Arrived​	December 3 1864​
51	2				2_1​	Forwarded​	Camp Douglas, Illinois​
52	2				2_1​	Date​	December 3, 1863​
53	2				2_1​	Arrived​	December 6, 1863​
54	2				13_1​	Discharged​	Per G.O. No. 109, A.G.O.​
55	2				13_1​	Date​	June 18, 1865​
57	3	Adams​	Peter​	L​	1_1	Army​	Confederacy
58	3				1_2	Location​	Texas
59	3				1_3	Regiment​	10th Regiment Texas Infantry (Nelson's)
60	3				1_4	Function​	Infantry
61	3				1_5	Company​	D
62	3				1_6	Rank​	Private
63	3				1_7	Age​	--
64	3				1_8	Residence​	--
65	3				1_9	Enrolled​	Fairfield, Freestone County, Texas
66	3				1_10	Date​	October 26, 1861
67	3				1_11	Enlisted​	Hempstead, Texas
68	3				1_12	Date​	October 31 1863
69	3				10_1	Absent​	January 1862-April 1864
70	3				11_1	Transferred​	Refugees from Arkansas Post
71	3				11_1	Unit​	Company L, 8th Regiment Texas Infantry, Young's Regiment
72	3				11_1	Date​	February 3, 1863

New Worksheet would look like this

Person_ID

Last Name​

First Name​

Middle​

Detail​

Date​

Relieved of Duty​

Date​

Captured​

Date​

Forwarded​

Forwarded​

Prisoner​

Died​

Cause​

Forwarded for Exchanged​

Date​

Hospital​

Location​

Date​

Captured​

Date​

Forwarded​

Forwarded​

Arrived​

Forwarded​

Date​

Arrived​

Discharged​

Date​

Absent​

Transferred​

Unit​

Date​

1

Able​

Ezekiel​

Hospital Nurse

November 8, 1862

Nurse

February 4, 1862

Battle of Arkansas Post

January 11, 1863

St. Louis, Missouri via Boats

Camp Douglas, Illinois via Rail

Camp Douglas, Illinois

March 7, 1863

Small Pox

2

Adams​

John​

H​

Battle Arkansas Post, Arkansas

January 11, 1863

St. Louis, Missouri via Boats

Camp Douglas, Illinois via Rail

Camp Douglas, Illinois

City Point, Virginia

April 10, 1863

Sick

Kingston, Georgia

March 22, 1864

Franklin, Tennessee

November 30, 1864

Nashville, Tennessee

Louisville, Kentucky

December 3 1864

Camp Douglas, Illinois

December 3, 1863

December 6, 1863

Per G.O. No. 109, A.G.O.

June 18, 1865

 

[Peter_SSs]

I completed the clean up and it ran as expected. Again, I really appreciate your help.

Good news. You're welcome. Thanks for the follow-up.