Moving values from single column to separate columns

Question

Hi,&nbsp;I have a table that looks like:Key&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13...101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 99101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 56101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 74...102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60...&nbsp;&nbsp;How do I change the structure of the table to look like:&nbsp;X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y_100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y_101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y_10210:00&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 99&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2011:00&nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 56&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4012:00&nbsp; &nbsp; &nbsp; &nbsp; 13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 74&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;60...&nbsp;&nbsp;

amitchandak · Accepted Answer

Anonymous , Pivot in Power BI 
https://radacad.com/pivot-and-unpivot-with-power-bi

Forum Discussion

Moving values from single column to separate columns

1 Reply

Related content

Move Columns

Split a column into two separate columns

moving average help

separate values into columns

Thousand-Separator-and-Decimal-Separator