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
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Bbrown44 

try a column

Column = SWITCH(TRUE(),
MOD([Index], 4) = 0, "Column A", 
MOD([Index], 4) = 1, "Column B", 
MOD([Index], 4) = 2, "Column C", 
MOD([Index], 4) = 3, "Column D", 
BLANK())