Duplicate values Based on Record ID

batista_randy

I have Data that looks like this 

1			Name1	Question 1
1				Question 2
1		CountryX		Question 3
1	XYZ			Question 4
1				Question 5
1				Question 6
2			Name2	Question 1
2				Question 2
2		CountryB		Question 3
2	ABC			Question 4
2				Question 5
2				Question 6

I want to duplicate the rows based on the number on column 1 so it looks like this. Note this is for multiple columns.

1	XYZ	CountryX	Name1	Question 1
1	XYZ	CountryX	Name1	Question 2
1	XYZ	CountryX	Name1	Question 3
1	XYZ	CountryX	Name1	Question 4
1	XYZ	CountryX	Name1	Question 5
1	XYZ	CountryX	Name1	Question 6
2	ABC	CountryB	Name2	Question 1
2	ABC	CountryB	Name2	Question 2
2	ABC	CountryB	Name2	Question 3
2	ABC	CountryB	Name2	Question 4
2	ABC	CountryB	Name2	Question 5
2	ABC	CountryB	Name2	Question 6

binu_acs

@batista_randy One way of doing this

Transpose_080124.yxmd