| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data
Please help if you know how to copy data from previous cell. For example, I
only have column A and column B. But I would like to have the person name on every row. Expected result is in column C. See example below... Col A Col B Col C (Expected Result) John apple John orange John kiwi John Mary grape Mary banana Mary apple Mary |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data
Let's make a column C and then paste/special/value back onto column A
In C1 enter: =A1 In C2 enter: =IF(A2="",C1,A2) and copy down Then take column C, copy it, and then paste/special/value back onto column A -- Gary''s Student gsnu200709 "NH" wrote: Please help if you know how to copy data from previous cell. For example, I only have column A and column B. But I would like to have the person name on every row. Expected result is in column C. See example below... Col A Col B Col C (Expected Result) John apple John orange John kiwi John Mary grape Mary banana Mary apple Mary |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data
Why bother with Column C?
You can copy the names in column A to the row below. Select column A and F5SpecialBlanksOK In active cell type = then point or up arrow to cell above. Hit CTRL + ENTER Copy column A and in place Paste SpecialValuesOKEsc. If you want to keep column A as is just copy it to column C and perform the above steps on column C. Gord Dibben MS Excel MVP On Tue, 6 Mar 2007 11:34:15 -0800, NH wrote: Please help if you know how to copy data from previous cell. For example, I only have column A and column B. But I would like to have the person name on every row. Expected result is in column C. See example below... Col A Col B Col C (Expected Result) John apple John orange John kiwi John Mary grape Mary banana Mary apple Mary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filted data, copy and paste a col. puts data in wrong row how fix | New Users to Excel | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| How do I copy data from main frame computer and keep data in cell | Excel Worksheet Functions | |||
| Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Linear Mode
