Good afternoon all,
I'm sure I've seen this one the forum somewhere, but can I find it now, can I heck.
I have a column of data in the middle of a worksheet (lets say column G), that has numbers in it and some may be multiples seperated by a comma.
I want to copy columns G & H, splitting multiples in column G onto new rows where necessary, and having column H populate these new rows.
See attachment for example
Reply With Quote