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
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
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