View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lyn Lyn is offline
external usenet poster
 
Posts: 35
Default Copy 3 columns become one column with macro

Dear Expert,

I have 3 columns data (for example column A, B and C) and I would like copy
to become one column data only, the example as below:

A B C D
Tomato 1 a Tomato
Sugar 2 b Sugar
3 c 1
d 2
3
a
b
c
d

Could you please advice me

Regards
Lyn