Date/Data Transformation

I do not know what this process would be called besides a pain.

I have a list of vehicles with data added by date in a horizontal manner:

ID Asset# 1-Jan-21 2-Jan-21 3-Jan-21
132 082-S132 195771 195771 195771
133 082-S133 188072 188072 188072
145 082-S145 179694 179694 179910

I need to convert this to a vertical format:

1-Jan-21 132 082-S132 195771
1-Jan-21 133 082-S133 188072
1-Jan-21 145 082-S145 179694
2-Jan-21 132 082-S132 195771
2-Jan-21 133 082-S133 188072
2-Jan-21 145 082-S145 179694
3-Jan-21 132 082-S132 195771
3-Jan-21 133 082-S133 188072
3-Jan-21 145 082-S145 179910

Outside of cut and paste - what tool in excel could help me automate or reduce effort. In scale - there are 5 years worth of mileage data, by day, for 150 vehicles in total. That's a lot of cut and paste.

if you have Microsoft Access, you can run N queries to transpose it.

So, my apologies. I never even thought to look at the profile - it was a little outdated....

Thank you on the Power Query-unpivot info. I am going to youtube post haste to learn how to do it.