Forum Discussion
Excel transpose and merge
Does anyone know a function or method in excel of getting data in a state from Illustration 1 to Illustration 2. Transform could be part of the solution but I need a way to consolidate rows and colum...
Power Query could help
- cool. I've never used before. do you happen to know how that could work and the steps?
Sure, if only you share sample file instead of screenshot
- i updated my post to include. much appreciated.
