Union Tool/Stacking Data

[reginawhelan]

Hi, I would like to stack data that is within one data source. I would like for the Names and DOB's be stacked into 3 columns instead of 9 with the Identifier carried over for each person. The following is an example of the current and desired output:

Current
Identifier	Person #1 First Name	Person # 1 Last Name	Person #1 DOB	Person #2 First Name	Person # 2 Last Name	Person #2 DOB	Person #3 First Name	Person # 3 Last Name	Person #3 DOB
123	Name1	Last Name1	1/10/1978	Name5	Last Name5	1/10/1978	Name9	Last Name9	1/10/1978
124	Name2	Last Name2	1/11/1978	Name6	Last Name6	1/11/1978	Name10	Last Name10	1/11/1978
125	Name3	Last Name3	1/12/1978	Name7	Last Name7	1/12/1978	Name11	Last Name11	1/12/1978
126	Name4	Last Name4	1/13/1978	Name8	Last Name8	1/13/1978	Name12	Last Name12	1/13/1978
Desired
Identifier	First Name	Last Name	DOB
123	Name1	Last Name1	1/10/1978
124	Name2	Last Name2	1/11/1978
125	Name3	Last Name3	1/12/1978
126	Name4	Last Name4	1/13/1978
123	Name5	Last Name5	1/10/1978
124	Name6	Last Name6	1/11/1978
125	Name7	Last Name7	1/12/1978
126	Name8	Last Name8	1/13/1978
123	Name9	Last Name9	1/10/1978
124	Name10	Last Name10	1/11/1978
125	Name11	Last Name11	1/12/1978
126	Name12	Last Name12	1/13/1978

[reginawhelan]

Thanks again!