Forum home » Delegate support and help forum » Microsoft Access Training and help » Database col fill
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Database col fill
Resolved · Medium Priority · Version 2003
Reply Mon 9 Jan 2012, 11:50
Edited on Mon 9 Jan 2012, 12:04Delegate Barry said...
Barry has attended:
No courses
Database col fill
Hi all, I have a database (over 18,000 rows) which shows the same name against different codes but they have the same postal address. What I am trying to do is put the same name against these codes with the same address other than copy & pasting the name against the codes with 18,000 it will take months to do. An example is below.
Code Names
XX12 SMITH
YY45
LL66
LL66
AA78 COURT
FF33
FF33
FF33
FF33
FF33
TT90 JAMES
TT90
HH14 HEART
HH14
HH14
RG49
Where the blanks are is where the names have to be filled in. For example SMITH also needs to be filled into the 3 rows below the name, COURT to go in the 5 rows below etc etc. Does anyone have any idea of the best way to fill in the blanks with the names? It can be in Access or Excel 2003.
Many thanks for any guidance.
Baz
For upcoming training course dates see: Pricing & availability
RE: Database col fill
Hi Barry, thanks for your query. Take the data into Excel and split it so Column A has the codes and column B has the names.
Copy column B, so it has the same names in the same positions.
In C2 put the following formula:
=IF(B2="", C1, B2)
Hit enter then autofill down from C2
Voila!
Hope this helps,
Anthony
Reply Mon 9 Jan 2012, 16:09Delegate Barry said...
RE: Database col fill
Hi Anthony, I take it the copied col B goes in to col "C"? Done that anyway & put your formula in C2. Copied down the formula over 18,000 rows & it worked a treat. I can now sort out the rest of the Excel s/sheet then import it into Access where I can continue working on it.
Great.
Thanks a lot Anthony. 5 stars for you m8.
Baz
|