Forum Discussion
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 used to do macro, that way I need to, because it's 2360 registed.
- Currently, I used manual vlookup as you can see in pic 2.
(1st column as lookup_value, 2nd column as index.)
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".
4 Replies
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".
