Forum Discussion
Formula to transpose one column into two
Hello there I’m not sure what the best formula is to transpose where for example I have one column for two categories combined . For example food category and food needs to be split into two, a vlook...
Riny_van_Eekelen thanks that kinda makes sense but I think where there is thousands of rows I don’t think that with work. Maybe the power query you mentioned might be my answer . Just not sure how to do it
Mellisa1260 See attached workbook that now contains a PQ solution. It will not be a problem to apply this on thousands of rows.
https://exceloffthegrid.com/power-query-introduction/
The above link could be a good starting point if you are new to PowerQuery.