Forum Discussion

Serdet's avatar
Serdet
Copper Contributor
May 17, 2023
Solved

Export data transformation

Hello,   I have a system that exports data in a poor fashion and I need help transforming this into readable data.   Standard export Date Name Total Hours A Hours B Hours C Hours D Hour...
excel
Formulas and Functions
Macros and VBA
  • Lorenzo's avatar
    Lorenzo
    May 17, 2023

    Hi Serdet 

     

    What HansVogelaar suggested gives the following. However, I'm not quite clear re. what you mean with For every A - D hours that has value greater than 0, it would need to create a new row and show this as hours for each available category

     

     

    Does this reflect what you expect? If not what's wrong/should be changed?

Resources