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
|