$$Excel-Macros$$ Converting from a single column to different rows

2012-05-19 Thread Anand Kumar
Hi, I have a data set where Name, Address, STD Codes, Phone Number, Mobile No. all are in a single column for different people. I want to have names in first column, Address in next column and std codes, phone numbers in next columns. How to do it using VBA? Sample data: Anil Kumar Gupta

Re: $$Excel-Macros$$ Converting from a single column to different rows

2012-05-19 Thread ashish koul
can you share the sample data On Sat, May 19, 2012 at 12:20 PM, Anand Kumar anand...@gmail.com wrote: Hi, I have a data set where Name, Address, STD Codes, Phone Number, Mobile No. all are in a single column for different people. I want to have names in first column, Address in next column

Re: $$Excel-Macros$$ Converting from a single column to different rows

2012-05-19 Thread dguillett1
Look in the help index for TRANSPOSE. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Anand Kumar Sent: Saturday, May 19, 2012 1:50 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Converting from a single column to different rows Hi, I have