I would like to know how I can take the values of a row and be able to pass to every three columns insert a different value of a row making it into a column
I tried some things(partitioning) but not working
Below is a hypothetical example from my current spreadsheet and how I want it to look.
Glad you found a way. Definitely unusual data manipulation you got there. Another approach would be to create collection columns from each of 3 columns, then do unpivoting and split collection column.