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

cols to rows

Hi

 

I am new to power bi,  just a silly question, this data i have downloaded from web, as you

can see col 1-4 is one set and then its a same cols again from col 5 to col 8,  is it possible to have col 5-8

to come under col 1-4 as its the same data and i need only col 1 to col 4 with the whole data.

 

instead of rank and rank 2 it should be only one col as rank, same as state and state 2 and viceversa.

 

please advise.

Capture.JPG