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 y...
Tutorial Requests
  • Bbrown44's avatar
    Bbrown44
    Icon for Advocate II rankAdvocate II
    6 years ago

    the Pivot default does not recognize that the data needs to be structure into 4 columns

     

    it pivots all the data long.  so then you have an infinite number of columns from the 1 column.