Reply
AER Frequent Visitor
Frequent Visitor
Posts: 4
Registered: ‎03-13-2017
Accepted Solution

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


Accepted Solutions
Member
Posts: 95
Registered: ‎03-16-2017

Re: Every other row to new column

[ Edited ]

Go to PowerQuery (via "edit queries")

Copy Table

Delete Alternate Rows in both

Join Tables by Column 2 into new table

View solution in original post


All Replies
Member
Posts: 95
Registered: ‎03-16-2017

Re: Every other row to new column

[ Edited ]

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
Posts: 4
Registered: ‎03-13-2017

Re: Every other row to new column

Of course, that worked very well, thanks!