Forum Discussion
Excel reformat/transpose bulk records
Hello, i am trying to find an automated way to reformat data in a (csv) spreadsheet to a new format that will be accepted as an import into another non office application. The problem i have is tha...
ferrariwa100 Looks like you need to look into PowerQuery and "unpivot".
Chapter 13 in the attached link tells you all about it. but follow through the "program" from the beginning if you are not familiar with PQ