Copy Rows into columns using VBA

November 3, 2016 at 11:49:17
Specs: Windows 7
Copy Rows into columns using VBA

1 have a very little experience with VBA, and I would really appreciate any help with this issue. I need to convert rows into columns from sheet 1 to sheet 2.

input file


Article ID EU-statistics Number of sheets Size of sheet Absorbancy With empties BOM (Empties Bill of Material)
1062 a 0 b 0 c
1065 a 0 b 0 c
1066 a 0 b 0 c
1071 a 0 b 0 c
1077 a 0 b 0 c
1081 a 0 b 0 c
1086 a 0 b 0 c
1090 a 0 b 0 c

Desire output file


Article ID
1062 EU-statistics a
1062 Number of sheets 0
1062 Size of sheet b
1062 Absorbancy 0
1062 With empties BOM (Empties Bill of Material) c
1065 EU-statistics a
1065 Number of sheets 0
1065 Size of sheet b
1065 Absorbancy 0
1065 With empties BOM (Empties Bill of Material) c
1066 EU-statistics a
1066 Number of sheets 0
1066 Size of sheet b
1066 Absorbancy 0
1066 With empties BOM (Empties Bill of Material) c


See More: Copy Rows into columns using VBA

Report •

#1
November 8, 2016 at 01:52:07
i Don't quite understand this, you need to present the data a little better, please use the PRE tags to format your data correctly, include column headings and row numbers to assist.

Read this
http://www.computing.net/howtos/sho...


Report •
Related Solutions


Ask Question