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?

Lorenzo's avatar
Lorenzo
Silver Contributor
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?

Serdet's avatar
Serdet
Copper Contributor
May 17, 2023
Unpivot works perfect. Thank you guys!

Resources