I have this data that I exported from our XCart site. Some of the data is horizontal, but then the details are vertical.
These columns are fine like they are: !ORDERID !ITEMID !PRODUCTID !PRODUCTCODE !PRODUCT !PRICE !AMOUNT !PROVIDER
But then the Data in Column J needs to be horizontal, like Account Number Invoice Number Invoice Comments
So I was trying to do it with a formula, but copying the formula didn't work at all.
I'd really like to have a VB Script that did this for me, because the woman needs this done everyone month.
Data attached.
Bookmarks