Create a new column with values from another column

[Anonymous]

I have a table with a number of columns (see picture). What I want to do is create one or two new columns based on the values of Column1. I want to have the values from like rowno 1,3,5 etc in a new column, they are all dates. As you can see the rest of the data in the table are all the same so I have duplicate values except for Column1,

I've also added columns at the end, index, index with mod and sub index, 

What is the best approach to accomplish this?

/Magnus

[Anonymous]

Hello-

  I am not 100% sure what you are looking for but I thought it would be a good idea for to play around with the Pivot and Unpivot columns in the transform and modeling sections.  This will likely give you the functionality you need.

Jared

[Anonymous · Accepted solution]

I created a new modulo column with 2 row interval. Then I created a custom column, if modulo index is 0 then get the value from Column1 otherwise set null. Then a new custom column checking if modulo index is 1 then get from Column1. After that I filled up the values for the second column. After that I filtered out the rows with modulo index = 1 🙂 The result looks like this

[Anonymous]

The data comes in rows set of two rows. The only stuff that differs is the values in column1. I want to have the date in one column and the text for example in another column then remove row no 2 in the set.