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

[nagakavyasri]

@batista_randy Another way of doing this:

[flying008]

Hi, @batista_randy 

FYI.

[grazitti_sapna]

Hi @batista_randy 
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks 

[batista_randy]

Hi, I don't have the option to concatenate on my summarize tool. Is there something I'm missing?

[batista_randy]

Disregard my last question as I just figured out how. The problem I am having now is the values have a ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," after the concatenate. What is causing this and how can I remove that? See example below.

,,CountryB,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,	,,,XYZ.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,CountryX,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,	,,,ABC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,CountryC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,	,,,BCD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

[flying008]

Hi, @batista_randy 

Maybe your fileds have many blank in the cells, so you need use Multi-Fields Formula tool to remove the unless space.