Forum Discussion
split multiple columns to multiple rows while matching base data
So suppose, in an organization, multiple team members are working on multiple projects. For some reason, whoever entered the data did it in the following way shown in the below screenshot. ...
You need to identify projects for start and end. As variant
- keep table with created lists as it is now
- reference it and extract projects for start
- reference again, zip end with reason and extract projects for them
- merge above on ID and Project
Please check details in attached.