Hi,
I am trying to get a marco to work to convert these two columns to rows.
Material code AU
WARD470091-652 KT
WARD470091-652 ST
WARD470102-264 EA
WARD470102-264 KT
WARD470102-264 ST
WARD470106-814 EA
WARD470106-814 KT
WARD470106-814 ST
WARD470124-494 EA
WARD470124-494 ST
WARD470124-496 EA
I need the first column grouped by Materical Code and the AU to go across in a row where the material codes match.
It should looks like this
WARD470091-652 KT ST
WARD470102-264E EA KT ST
Any help is appreciated!
Thanks,
Cheryl
Bookmarks