Multiple Duplications

[mquast]

I am trying to duplicate the 2nd column 35 times and insert all of them to the left of column 2 and duplicate the last column 44 time and insert them to the right. I was wondering if there was a faster way then using multiple formula tools.

[Qiu · Accepted solution]

@mquast 
I use the Generate Row tools to duplicate the columns.

1. First we can do the transpose then filter out the 2nd and last column by their Filed Name

2. Generate Rows tool to generate the necessary coumns then Union Back with the original data stream

3. Cross Tab and Sort will bring the data back to orginal format.

[flying008]

Hi, @mquast 

Another way for this case.