Forum Discussion
Move columns into one column
in Table view, I have a table with columns of different tasks types, tasks due date and name assigned to task. the data source is an excel spreadsheet. eg of layout. Name Task 1 Tas...
thank you all, thats great.
Let me know if I am on the right track ..
The orginial table to remain untouched.
Therefore, in Edit query, on the orginal table I selected Reference. This creates a reference table. I deleted columns no longer needed. I noticed calculated columns created in the orginial table, are not available in the Reference table. Does that mean in Table view, I need to add the calculated columns. Once completed. in the Reference table I will unpivot the columns
You can apply all changes on your table in power query.
download my sample file and follow the steps
regards
vahid
