Hey all, I was hoping to get some macro working for this specific job and I thought it would be nice to ask you for it. Well, I have data in column A with around 100 rows. in column B there are 2 letter abbreviations which I achieved using left(A1,2) formula. Then I deleted duplicate values in column B. So the abbreviations are short like 30 rows because its not being repeated. so now what I need is a code that can put in front of each abbreviation the data matched in column A in seperate columns.
for instance:
Column A
Row 1--- cat
Row 2--- can
Row 3--- caffien
Row 4--- cash
Row 5--- map
Column B
Row 1--- ca
Row 2--- ma
Result should be:-
Column C
Row 1--- cat
Row 2--- map
Column D
Row 1--- can
Column E
Row 1--- caffien
Column F
Row 1--- cash
Hope it make sense,
will be appreciating any help at all,
Thanks.
for instance:
Column A
Row 1--- cat
Row 2--- can
Row 3--- caffien
Row 4--- cash
Row 5--- map
Column B
Row 1--- ca
Row 2--- ma
Result should be:-
Column C
Row 1--- cat
Row 2--- map
Column D
Row 1--- can
Column E
Row 1--- caffien
Column F
Row 1--- cash
Hope it make sense,
will be appreciating any help at all,
Thanks.