Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Moving data
I have customer information in column A. It looks like this:
customer address phone customer address phone and so on for over 500 customers. How can I move the data so it fills a1:c500? So it would look like: customer address phone customer address phone and so on. Thanks for any help, -- Gary Beard |
#2
|
|||
|
|||
one way:
In a second sheet enter: A1: =INDEX(Sheet1!A:A,4*(ROW()-1)+1) B1: =INDEX(Sheet1!A:A,4*(ROW()-1)+2) C1: =INDEX(Sheet1!A:A,4*(ROW()-1)+3) Copy down as far as necessary. Then select columns A:C on the second sheet. Copy, then Paste Special, selecting the Values radio button. In article , "gbeard" wrote: I have customer information in column A. It looks like this: customer address phone customer address phone and so on for over 500 customers. How can I move the data so it fills a1:c500? So it would look like: customer address phone customer address phone and so on. Thanks for any help, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |