Forum Discussion
Transpose columns and duplicate rows
Good morning community,
I have the following database, where each date indicates a stage.
What I need to do is transpose only the dates and that in turn create a new column with a name X (stage date) and the new name of the dates (start date) but that duplicate the row in this case the application, project and resource the times I transposed the dates, that is, 4 times. As seen in the table below.
Does anyone have an idea how to do it? Thank you!
Hello Syndicate_Admin ,
the duplication of the application, project, and resource is normal and will stay like this.
what you do is the following:
click on the first 3 columns and then click unpivot other columns
2 Replies
Hello Syndicate_Admin ,
the duplication of the application, project, and resource is normal and will stay like this.
what you do is the following:
click on the first 3 columns and then click unpivot other columns
Thank you very much, it worked perfect!
