RPatel0531
New Member
- Joined
- Mar 15, 2022
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hello,
I need to find a way to take an excel sheet that has employee names listed several times in Column A and then it has several earnings codes in column b with earnings amount in Column D with different data and find a way to combine all the data also in the other rows together so I don't lose that information either.
I want to instead have one name for each employee and take those earnings codes and make them into the column heading and then pull the earnings amount to that column heading so i don't have 5 or 6 rows for each employee.
I need to find a way to take an excel sheet that has employee names listed several times in Column A and then it has several earnings codes in column b with earnings amount in Column D with different data and find a way to combine all the data also in the other rows together so I don't lose that information either.
I want to instead have one name for each employee and take those earnings codes and make them into the column heading and then pull the earnings amount to that column heading so i don't have 5 or 6 rows for each employee.