Forum Discussion
Solved
Horizontal Dataset to Vertical Dataset
I have an issue about transforming Check-in dataset (Horizontal) to DB dataset (Vertical) as you can see in pic 1 and pic 2. Is there a solution without macro to solve this issue, please? - I us...
james0862 Attached a small example. A good starting point would be the site in the link below.
https://exceloffthegrid.com/power-query-introduction/
....and in particular, chapter 13 "Unpivoting data".
james0862 Can be done fairly easily with Power Query, a built-in Excel feature. Not for the Mac though!
No VBA needed.
Is there a proper key word used for this issue for googling?
james0862 Attached a small example. A good starting point would be the site in the link below.
https://exceloffthegrid.com/power-query-introduction/
....and in particular, chapter 13 "Unpivoting data".
- Thank you a lot Riny_van_Eekelen, this help me lots.
I have search for this topic for 2 days.