Transpose Table with most string/ dimensions from row to column

[PrajS]

Hi Experts ,

How can I transpose my Data  table that has mostly dimensions from row to a column 

Current result 

Customer ID	Customer Name	PhNo	Email Address	Location
1	ABC	123	dfg	qwe

Desired Result

Customer ID	1
Customer Name	ABC
PhNo	123,567
Email Address	dfg
Location	qwe

Need Help here. I hav tried Pivot, That is not helping me much here. Am also using concatenation of rows like concat(Phone,',')

Any help is appreciated

Thank you 

[arulsettu · Accepted solution]

Maybe like this

CrossTable(rows,values)
load * Inline [
Customer_ID, Customer_Name, PhNo, Email_Address, Location
1, ABC, 123, dfg, qwe

];

[PrajS · Accepted solution]

Yes that was the solution Thank you