Unstack Multiple Columns of Data

How to unstack multiple columns of data using VBA. Watch the video below: Here’s the complete VBA code:Sub DataFormatting() Dim lastrow As Long, i As Long, k As Long, ponum As Long, totvalue As Long Dim MaterialCode As Stringk = 6totvalue = 0Dim nextblankrow As Longnextblankrow = Sheet1.Cells(Rows.Count, 6).End(xlUp).Offset(1, 0).Rowlastrow = Application.WorksheetFunction.CountA(Range(“A:A”)) MaterialCode = InputBox(“Enter […]