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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,420
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,118,861
Messages
5,574,708
Members
412,613
Latest member
EFRATA
Top