Rearrange columns and rows in table

Question

Hello community 🙂&nbsp;Is there anyway to rearrange columns and values? Quite struggling to re-arrange columns for the Gantt Chart.&nbsp;For example, my data table is like this:(To explain data little bit details, once model finished step 1 it started step 2 duration and it keeps going to step 5 and it finished operation)&nbsp;&nbsp;I want to make table like this:&nbsp;Is there any method to convert table like this? Currently, my data has over 30000 unique id so it's not easy that i thought..If anyone knows to convert table like this please let me know!Thank you so much for your help and happy halloween 🙂&nbsp;&nbsp;Kind regards,jean

v-zhangti · Accepted Answer

Hi,&nbsp;heejinyune&nbsp;
&nbsp;
You can try the following methods.&nbsp;In Power Query, copy the tables into five copies, leaving only 2 columns for each table.Table1 and Table2:

&nbsp;
Select the Step 1 column in Table 1 and click Unpivot Column.&nbsp;The result is shown in the figure.

Other tables are also set up like this.

&nbsp;
Finally, use the Append function to add several tables to one table.

Result:

Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;

Forum Discussion

Rearrange columns and rows in table

2 Replies

Related content

Table Column Sort/Reorder/Rearrange

Split and rearrange columns

Rearrange columns

Power BI Model - Rearrange Columns in table inside Model

Rearrange Hierarchy?