Conversion/Normalization of data in Tabular form

[mohsin-raza]

Hello:

Can some body help me in conversion data in given form into proper tablular form in  power query? Is this related to  the  concept of pivot and unpivot data. 

registrationNumber	AYH566
archiveStatus	0
country	UK
customLabel	AYH566 - VPU 330
registrationNumber	ALG322
archiveStatus	0
country	AL
customLabel	ALG322 - SBLB-129
registrationNumber	AKY758
archiveStatus	0
country	USA
customLabel	AKY758 - 1648 hdm -
registrationNumber	AKA749
archiveStatus	0
country	FR
customLabel	AKA749 VW  2KN
registrationNumber	ALK431
archiveStatus	0
country	UK
customLabel	ALK431 -4MNB
registrationNumber	AMK483
archiveStatus	0
country	UK
customLabel	AMK483 -  VPU 330

[mohsin-raza]

@SergioSilvaPT  

Thanks alot . It works and with more query steps ,the data is  tabular form now

.

[SergioSilvaPT]

Glad i could help!

[SergioSilvaPT · Accepted solution]

Hi @mohsin-raza 

You must do the following:

This is your source:

Click in Add Column -> Index Column and you get this:

Then select Index and (blank) columns and go to Transform and click on Pivot Column :

and you will get this:

Remove the Index column by right clicking and chosing Remove Column.

It's done!

You can replace all the null with blank by selecting all columns and go to Transform -> Replace Values

Regards,

Sérgio Silva 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

[mohsin-raza]

@SergioSilvaPT 

 Thanks for the solution . It looks very fine with the result you produced .

In step 2 when i select blank and index and chose Pivot column . I am not getting the same result. Pivot column also ask for choice of column ?

On selecting  any of the column  i am not getting the same answer..

can you see  it?

 and 

[SergioSilvaPT]

Sorry @mohsin-raza i have updated my post.

Please check it again!