| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple same rows only one column changes
Hi:
I want to arrange some data in Excel. The data are in the following format: Contact1 Address1 Phone1 Email1 Contact1 Address1 Phone1 Email2 Contact1 Address1 Phone2 Email1 Contact1 Address1 Phone2 Email2 and so on.... As you can see, only the column that contains phones and emails changes. I want to put them in a new sheet in the following format. Contact1 Address1 Phone1 Phone2 Email1 Email2 (all the data for a particular contact in a row) Do you have any idea how should I tackle this issue? Thanks a lot in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing One Column to Multiple Rows | Excel Worksheet Functions | |||
| Select multiple rows and add a value in a column | Excel Programming | |||
| Way to put multiple rows into the same column. | Excel Discussion (Misc queries) | |||
| Multiple rows to one column | Excel Programming | |||
| Problem when trying to convert one column with multiple rows to one row with multiple column | Excel Programming | |||
Threaded Mode
