Reply
Frequent Visitor
Posts: 5
Registered: ‎10-20-2018

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