Forum Discussion
data transformation
Hello all,
need an urgent help.
Im working on a time sheet task .Im quite to this .
| employee-project | casted hours |
| employee1 | 48 |
| d1 | 40 |
| d2 | 40 |
| holiday | 8 |
| employee2 | 48 |
| d1 | 20 |
| d3 | 20 |
| d4 | 8 |
| emmployee3 | 24 |
| d4 | 16 |
| holiday | 8 |
i have a table like this which listed the employees and their department ids and the hours forecasted to it .
imgine more than 100 employees in the list and their diffrent department ids and forecasted time .
I wan to convert this table to a form which mentioned below.and it has to be works for all the employees data .please help me
| employee details | d1 | d2 | holiday | d3 | d4 |
| employee1 | 40 | 40 | 8 | ||
| employee2 | 20 | 20 | 20 |
5 Replies
ashikts , Please check the power Query Transformation in the file attached after signature
Added columns
Remove First Colum
Pivot data
amitchandak hello sir, thanks for the explanation ,but the names of the employee are diffrent .
eg,instead of employee1 it is ashik, employee 2 it is amal etc like that
in that case how we can able to do this ?
ashikts , is there any other way we can differentiate either employee or non-employee data. That can do.
Please share some sample similar to what you have in the real cases(Not exact).
