View Single Post
 
Old 01-02-2018, 10:59 AM
josbor01 josbor01 is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2018
Posts: 2
josbor01 is on a distinguished road
Default little more info

Thanks, that helps; but of course, need a little more help with the range and to pull out specific columns. I have provided additional columns and data elements

input data: {sheetX}
Item{A} Description{B} data1{D} data2{G} quantity{J} Loc1{K} loc2{L}
101 Description101 data101_1 data101_2 1 M1 C1
102 Description102 data102_1 data102_2 2 M1 C2

needed/expected output: {label_data}
Item{A} Description{B} data1{C} data2{D} quantity{E} Loc1{F} loc2{G}
101 Description101 data101_1 data101_2 1 M1 C1
101 Description101 data101_1 data101_2 1 M1 C1
102 Description102 data102_1 data102_2 2 M1 C2
102 Description102 data102_1 data102_2 2 M1 C2
102 Description102 data102_1 data102_2 2 M1 C2
102 Description102 data102_1 data102_2 2 M1 C2
Reply With Quote