Forum Discussion

Bbrown44's avatar
Bbrown44
Icon for Advocate II rankAdvocate II
6 years ago
Solved

convert 1 column into 4 columns

Hello,

 

I have data in one row that consist of 4 variables.

 

What I want is

Every 1st row = Column A

Every 2nd row = column B

Every 3rd row = column c

Every 4th row = column D

 

So when you get to the 5th row you loop back to

 

5th row = Column A

 6throw = column B

7th row = column c

8th row = column D

 

And so on in this loop until the rows of data are exhausted.

 

See image below as for the structure of data

 

 

 

5 Replies