Moving data

M

melbeline

I am attempting to combine information from one sheet into another and I do
not have a clue how to do this for almost a thousand contacts. Any
suggestions? Thanks in advance for any assistance.

Below is an example of what sheet 1 and sheet 2 look like:

Sheet 1

Co. Name Address City Zip
ABC 123 Oak Abe 91456


Sheet 2

Co Name ABC
Address 123 Oak
City Abe
Zip 91456
 
H

Hans Knudsen

melbeline said:
I am attempting to combine information from one sheet into another
and I do not have a clue how to do this for almost a thousand
contacts. Any suggestions? Thanks in advance for any assistance.

Below is an example of what sheet 1 and sheet 2 look like:

Sheet 1

Co. Name Address City Zip
ABC 123 Oak Abe 91456


Sheet 2

Co Name ABC
Address 123 Oak
City Abe
Zip 91456


I am not quite sure what you want.
If you have data as:

Co. Name Address City Zip
ABC 123 Oak Abe 91456
in A1:D(x) in Sheet1 and you want your data to appear as:

ABC
123 Oak
Abe
91456
in A1:A(4x) in Sheet2
then enter in Sheet2!A1 the formula:
=INDEX(Sheet1!A:D,(ROW()-1)/4+2,MOD(ROW()-1,4)+1)

Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top