cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AER Frequent Visitor
Frequent Visitor

Every other row to new column

Hi, 

 

I try to split one comlumn into two coulums, with less rows

 

I have this:

Row      Column1   Column2

1             1234           0

2             ABCD          0

3             4321           1

4             DCBA          1

5             2341           2

6             BCDA          2

 

Want this:

Row      Column1   Column3

1             1234           ABCD

2             4321           DCBA

3             2341           BCDA

 

Is there any way of doing this?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
cs_skit Member
Member

Re: Every other row to new column

Go to PowerQuery (via "edit queries")

Copy Table

Delete Alternate Rows in both

Join Tables by Column 2 into new table

2 REPLIES 2
cs_skit Member
Member

Re: Every other row to new column

Go to PowerQuery (via "edit queries")

Copy Table

Delete Alternate Rows in both

Join Tables by Column 2 into new table

AER Frequent Visitor
Frequent Visitor

Re: Every other row to new column

Of course, that worked very well, thanks!