Hello all,

A client sent me an excel file with addresses of all of their customers that
they need modified before their printing company will accept it and print out
mailing labels. Currently their data is in a row by row basis with an empty
row between the starting of the next address. So an example would look like
this

(A1) John & Susie Jones
(A2) 123 Fake Street
(A3) Washington, DC 12345


However their printing company will ONLY take the excel spread sheet if data
is in the following format:

(A1) (B1) (C1)
John & Susie Jones 123 Fake Street Washington, DC 12345


Now here is the kicker, I normally could do this by hand except they have
around 15,000 addresses per worksheet and 5 worksheets total.

Does anyone know how I can convert this data for them so that a full address
is in a single row instead of multiple rows and not do this manually? I'm
charging this client on an hourly basis to do this data conversion and I
doubt they want a $3000 invoice. Is there a macro or conversion utility??

Thanks!

Brad W

Edit -Copy-Paste-Transpose

"Brad W" wrote:

Hello all,

A client sent me an excel file with addresses of all of their customers that
they need modified before their printing company will accept it and print out
mailing labels. Currently their data is in a row by row basis with an empty
row between the starting of the next address. So an example would look like
this

(A1) John & Susie Jones
(A2) 123 Fake Street
(A3) Washington, DC 12345


However their printing company will ONLY take the excel spread sheet if data
is in the following format:

(A1) (B1) (C1)
John & Susie Jones 123 Fake Street Washington, DC 12345


Now here is the kicker, I normally could do this by hand except they have
around 15,000 addresses per worksheet and 5 worksheets total.

Does anyone know how I can convert this data for them so that a full address
is in a single row instead of multiple rows and not do this manually? I'm
charging this client on an hourly basis to do this data conversion and I
doubt they want a $3000 invoice. Is there a macro or conversion utility??

Thanks!

Brad W

I tried that, however what happens is that the data becomes one long
continuous stream of unending addresses in A1.

The printer wants to have the first address and all subsequent addresses to
read

(1) John & Susie Jones 123 Fake Street Washington, DC 12345
(2) John Doe 456 Street Road City, Zip
(3) Jane Doe 789 my address my city zip

Where as when doing the transpose everything looks like this:

(1) John & Susie Jones 123 Fake Street Washington, DC 12345 John Doe 456
Street Road City, Zip Jane Doe 789 my address my city zip

Is there anyway around that?


"dls61721" wrote:

Edit -Copy-Paste-Transpose

"Brad W" wrote:

Hello all,

A client sent me an excel file with addresses of all of their customers that
they need modified before their printing company will accept it and print out
mailing labels. Currently their data is in a row by row basis with an empty
row between the starting of the next address. So an example would look like
this

(A1) John & Susie Jones
(A2) 123 Fake Street
(A3) Washington, DC 12345


However their printing company will ONLY take the excel spread sheet if data
is in the following format:

(A1) (B1) (C1)
:


Now here is the kicker, I normally could do this by hand except they have
around 15,000 addresses per worksheet and 5 worksheets total.

Does anyone know how I can convert this data for them so that a full address
is in a single row instead of multiple rows and not do this manually? I'm
charging this client on an hourly basis to do this data conversion and I
doubt they want a $3000 invoice. Is there a macro or conversion utility??

Thanks!

Brad W

Pls Provide the excel file with 40 to 50 Example.

Hardeep kanwar



"Brad W" wrote:

I tried that, however what happens is that the data becomes one long
continuous stream of unending addresses in A1.

The printer wants to have the first address and all subsequent addresses to
read

(1) John & Susie Jones 123 Fake Street Washington, DC 12345
(2) John Doe 456 Street Road City, Zip
(3) Jane Doe 789 my address my city zip

Where as when doing the transpose everything looks like this:

(1) John & Susie Jones 123 Fake Street Washington, DC 12345 John Doe 456
Street Road City, Zip Jane Doe 789 my address my city zip

Is there anyway around that?


"dls61721" wrote:

Edit -Copy-Paste-Transpose

"Brad W" wrote:

Hello all,

A client sent me an excel file with addresses of all of their customers that
they need modified before their printing company will accept it and print out
mailing labels. Currently their data is in a row by row basis with an empty
row between the starting of the next address. So an example would look like
this

(A1) John & Susie Jones
(A2) 123 Fake Street
(A3) Washington, DC 12345


However their printing company will ONLY take the excel spread sheet if data
is in the following format:

(A1) (B1) (C1)
:


Now here is the kicker, I normally could do this by hand except they have
around 15,000 addresses per worksheet and 5 worksheets total.

Does anyone know how I can convert this data for them so that a full address
is in a single row instead of multiple rows and not do this manually? I'm
charging this client on an hourly basis to do this data conversion and I
doubt they want a $3000 invoice. Is there a macro or conversion utility??

Thanks!

Brad W