2 dimension table convert

[tonny_bwg]

Dear Guru：

Need your help to convert a 2-dimension table to 1-dimension table, for details,please take a look at attached file. 

from Column A to Column F, Each row represents a part.  From Column G to last column represent test result. every five column is a group of test. which includes test value, Low Limit, High Limit, Critiria and test result. 

Expected format:

thanks for the help.

--Tonny

[v-yangliu-msft]

Hi  @tonny_bwg ,

Here are the steps you can follow：

1. Select  [Unld SPD1 outPut Motor Speed [RPM]], [Unld SPD1 outPut Motor Speed] , [Unld SPD1 outPut Motor Speed H.Lmt].

Transform – Unpviot Columns.

2. Result:

Best Regards,

Liu Yang

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

[tonny_bwg]

https://docs.google.com/spreadsheets/d/1qs9JSIuH9kzlCKlXHfYmUV7RE1_fQQCj/edit?usp=share_link&ouid=11... 

Hi，Gurus
 sample file has been attached with hyperlink，please help with it.

thanks 

--Tonny

[lbendlin]

Nothing attached?  Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523