I was wondering if someone could help me with a formula that would take a vertical set of data and turn it to a horizontal set of data. The horizontal data can only run for 8 columns until it starts a new row. I show this in the xls I attached.
For example,
Item Name Price
W1402 CRYSTAL 200
W1404 CRYSTAL 200
W1403 CRYSTAL 200
W1405 CRYSTAL 200
W1407 ADVERT 175
W1408 JET 270
W1409 JET 270
W1418 ARROWHEAD 190
W1419 ARROWHEAD 190
W1420 ARROWHEAD 190
(Output)
W1402 W1404 W1403 W1405 W1407 W1408 W1409 W1418 (((after 8 columns, go down 3 rows)))
CRYSTAL CRYSTAL IT CRYSTAL CRYSTAL ADVERT JET ARROWH ARROW
200 200 200 200 175 270 270 190
W1418 next item
ARROW next name etc.... -->
190 next price
I appreciate any help. Thanks in advance.
dataoutput.xlsx
Bookmarks