Link to home
Start Free TrialLog in
Avatar of gisvpn
gisvpnFlag for United States of America

asked on

Simple Macro to Single Column Values

Hello,

I have the attached spreadsheet with two columns of data - the first with a single value (col A) in and the second (col B) with either no value, a single value or multiple values with many values in separated by a comma (all multiple values are separated by a comma).

I could like to keep Col A as it is however I would like all the values in column B to be separated (if there are multiple in a cell) and copied to column A as single values or just copied to column A where there is a single value (i.e. no comma indicating multiple values) and just ignored if no value.

Could someone tell me if this is possible and how I may tackle this?

Many thanks in advance.

Regards

GISVPN
Book1---Copy.xlsx
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Quick question your delimiter in Column-B are not constant at row number-2 its semicolon but then in row number -9 you have semi-colon and colon..

Do you have a constant delimiter like you said in your question comma or it will be always like this??

Saurabh...
Avatar of gisvpn

ASKER

Hi there it could be either a semi colon or a colon! Sorry should have said this too!
Avatar of gisvpn

ASKER

A comma should never be used!
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gisvpn

ASKER

Great quality answer