scardadeiro
New Member
- Joined
- Jun 22, 2015
- Messages
- 1
Hello,
I'd like to split content from one cell into multiple rows, and vice versa, with specific formatting. I think the only quick way to do this is via a Macro, but I'm not familiar with VBA at all. Can anybody lend a hand? These take too long to format manually, especially with thousands of rows:
Pre-format:
Post format:
Essentially, each email address needs to be on it's own separate line, while including a
separated list of all order #s and PO #s in their own single cells.
I'd like to split content from one cell into multiple rows, and vice versa, with specific formatting. I think the only quick way to do this is via a Macro, but I'm not familiar with VBA at all. Can anybody lend a hand? These take too long to format manually, especially with thousands of rows:
Pre-format:

Post format:

Essentially, each email address needs to be on it's own separate line, while including a
separated list of all order #s and PO #s in their own single cells.