Transposing data with multiple fields

[Jranchhod]

Good day

Please can I ask for assistance.

I would like to transpose data I have client information in row format

Name	Surname	Home	Work	Cell
Jetash	Amith	101 205 1256	525 962 3568	395 886 9135

<colgroup><col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;"><colgroup><col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;"><colgroup><col width="128" style="width: 96pt; mso-width-source: userset; mso-width-alt: 4681;"><colgroup><col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"><colgroup><col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;"><tbody>
</tbody>

I would like to transpose the information to the following

Name	Surname	Telephone number	Number type
Jetash	Amith	101 205 1256	Home
Jetash	Amith	525 962 3568	Work
Jetash	Amith	395 886 9135	Cell

<colgroup><col width="212" style="width: 159pt; mso-width-source: userset; mso-width-alt: 7753;" span="4"> <tbody> </tbody>

Please can I ask for assistance

Thank you


Jetash

 

[sandy666]

try PowerQuery (Get&Transform)

Name	Surname	Home	Work	Cell		Name	Surname	Telephone Number	Number Type
Jetash	Amith	101 205 1256	525 962 3568	395 886 9135		Jetash	Amith	101 205 1256	Home
						Jetash	Amith	525 962 3568	Work
						Jetash	Amith	395 886 9135	Cell

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Name", "Surname"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Other Columns",{"Name", "Surname", "Value", "Attribute"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Value", "Telephone Number"}, {"Attribute", "Number Type"}})
in
    #"Renamed Columns"[/SIZE]