I have a purchase order with around 1000 items. We converted it from a .pdf to an Excel file in order to be able to manipulate the PO info in order to send to separate suppliers.

Tonight, I figured out how to use the CONCATENATE and TRANSPOSE functions along with line breaks to move the detail lines for each item from separate cells into one cell as shown above. This way, I can have one item per row vs several rows per item. I have a separate spreadsheet with my item number, quantity, price, etc in one row. I'll be copying column B and pasting into this spreadsheet and after resizing the rows to fit the merged cells, everything will look ok.

Since there are around 1000 items, completing the CONCATENATE and TRANSPOSE exercise would take a long time and our man hours are better used elsewhere. I'm looking for a solution where I can select the range of cells I want to use the CONCATENATE and TRANSPOSE functions on to move the item detail lines from several cells to one for each item. The number of detail lines for each item varies from 3 to 12 so I'd like to be able to select the range of cells to combine and have Excel do the work for me.

Any suggestions or ideas?

Macros and VBA are your friends

quote:

---

Macros and VBA are your friends

---

Or use PYTHON!

I don't really have time to learn VBA. Any good websites where I can pay someone to write a macro for me?

bump

Seems reasonable. If you could get me the spreadsheet, I could take a swing at it.

Thanks logs. My e-mail is anaggiefan AT gmail.com. Send me your address and I can send you some info.

Email sent.