Horizontal Dataset to Vertical Dataset

[james0862]

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.)

[#2]

@james0862 Can be done fairly easily with Power Query, a built-in Excel feature. Not for the Mac though!

No VBA needed.

[#3]

Is there a proper key word used for this issue for googling?

[#4 · Accepted solution]

@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".

[#5]

Thank you a lot @Riny_van_Eekelen, this help me lots.
I have search for this topic for 2 days.