Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying different repeating entries down a column
Hi all,
I have an Excel spreadsheet with a layout similar to the following: A1 = 'Dr. Johnson' A2 = (blank) A3 = (blank) A4 = (blank) A5 = 'Dr. Deperi' A6 = (blank) A7 = (blank) A8 = 'Dr Marise' etc. etc. etc. For better use of pivot tables & filtering, I would like to copy the existing names into their corresponding blank cells, which happen to appear directly below the name. So, using the above example, what I am trying to find is a quick method that would give me the following result: A1 = 'Dr. Johnson' A2 = 'Dr. Johnson' A3 = 'Dr. Johnson' A4 = 'Dr. Johnson' A5 = 'Dr. Deperi' A6 = 'Dr. Deperi' A7 = 'Dr. Deperi' A8 = 'Dr Marise' etc. etc. I have over 2000 rows to populate. Can anyone help? Thanks! Joe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying different repeating entries down a column
Hi!
Use a temporary helper column. Formula in B1: =A1 Formula in B2: =IF(A2="",B1,A2) Copy down to the end of the data range in column A. Then you can convert these formulas to constants and delete the original column A if desired. Biff "Access Joe" wrote in message ... Hi all, I have an Excel spreadsheet with a layout similar to the following: A1 = 'Dr. Johnson' A2 = (blank) A3 = (blank) A4 = (blank) A5 = 'Dr. Deperi' A6 = (blank) A7 = (blank) A8 = 'Dr Marise' etc. etc. etc. For better use of pivot tables & filtering, I would like to copy the existing names into their corresponding blank cells, which happen to appear directly below the name. So, using the above example, what I am trying to find is a quick method that would give me the following result: A1 = 'Dr. Johnson' A2 = 'Dr. Johnson' A3 = 'Dr. Johnson' A4 = 'Dr. Johnson' A5 = 'Dr. Deperi' A6 = 'Dr. Deperi' A7 = 'Dr. Deperi' A8 = 'Dr Marise' etc. etc. I have over 2000 rows to populate. Can anyone help? Thanks! Joe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying different repeating entries down a column
BIff,
Thanks, this works great. Joe "Biff" wrote: Hi! Use a temporary helper column. Formula in B1: =A1 Formula in B2: =IF(A2="",B1,A2) Copy down to the end of the data range in column A. Then you can convert these formulas to constants and delete the original column A if desired. Biff "Access Joe" wrote in message ... Hi all, I have an Excel spreadsheet with a layout similar to the following: A1 = 'Dr. Johnson' A2 = (blank) A3 = (blank) A4 = (blank) A5 = 'Dr. Deperi' A6 = (blank) A7 = (blank) A8 = 'Dr Marise' etc. etc. etc. For better use of pivot tables & filtering, I would like to copy the existing names into their corresponding blank cells, which happen to appear directly below the name. So, using the above example, what I am trying to find is a quick method that would give me the following result: A1 = 'Dr. Johnson' A2 = 'Dr. Johnson' A3 = 'Dr. Johnson' A4 = 'Dr. Johnson' A5 = 'Dr. Deperi' A6 = 'Dr. Deperi' A7 = 'Dr. Deperi' A8 = 'Dr Marise' etc. etc. I have over 2000 rows to populate. Can anyone help? Thanks! Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
splitting worksheet by column entries | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) |