Excel formula to 'append' information together?

Exceliott

New Member
Joined
Jul 25, 2019
Messages
1
Hi all -

I am attempting to use Excel to find information from one table and assign it to other tables....which is normally easy....but there is a conundrum I have run across.

For example:


I currently have this information:
Standard SectionActivity
200.01-14627
200.15-17644
200.15-171098
200.15-171099
200.15-17788
200.18628

<tbody>
</tbody>





Separately, I also currently have this info:
Standard Section
200.01-14
200.01-14
200.01-14
200.01-14
200.15-17
200.15-17
200.15-17
200.18
200.18

<tbody>
</tbody>


I am attempting to do something like this (Using the rows from Table 2, but assign the 'Activity' numbers from Table 1):

Standard SectionActivity
200.01-14627
200.01-14627
200.01-14627
200.01-14627
200.15-17644; 1098; 1099; 788
200.15-17 - "Or the 'Activity' Numbers could be in separate columns…and that would be ok....similar to the below"
200.15-1764410981099788
200.18628
200.18628

<tbody>
</tbody>




Essentially I am trying to pull information from one table and assign it to a second table. But, there are multiple 'Activity' numbers in Table 1 within a particular 'Standard Section'.

I attempted within MS Access, but the primary key problem halted me, as the two tables may have duplicate fields of what could be the primary key.


Any help is greatly appreciated. Thanks in advance.

Eliott
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,161
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel board!

See if this is any use. Table below in columns A:B is "Table1" while "Table2" is in columns E:F

Enter the shown formula in F2 & it should fill down the table.
It is an array formula so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}.

Excel Workbook
ABCDEF
1Standard SectionActivityStandard SectionActivity
2200.01-14627200.01-14,Table1,&quot;&quot;))}]627
3200.15-17644200.01-14627
4200.15-171098200.01-14627
5200.15-171099200.01-14627
6200.15-17788200.15-17644; 1098; 1099; 788
7200.18628200.15-17644; 1098; 1099; 788
8200.15-17644; 1098; 1099; 788
9200.18628
10200.18628
11
Lookup
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,525
Messages
5,523,377
Members
409,514
Latest member
MarkZuckerberg

This Week's Hot Topics

Top