Excel Automation From Horizontal to Vertical

Irfanilham

New Member
Joined
Oct 2, 2020
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
horizontal.PNG

This is the horizontal format

Vertical.PNG

This is the example of vertical format I am looking for, is a there faster way (automation/vba) for me to use?
I have been doing it manually
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,441
try Power Query (Get&Transform) with unpivot selected columns, maybe it will work
 

Irfanilham

New Member
Joined
Oct 2, 2020
Messages
4
Office Version
  1. 2016
Platform
  1. Windows
Ok do you have any examples or good tutorial that i should watch?
 

Watch MrExcel Video

Forum statistics

Threads
1,119,058
Messages
5,575,850
Members
412,688
Latest member
KYLE1788
Top