# Excel formula to 'append' information together?

#### Exceliott

##### New Member
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 Section Activity 200.01-14 627 200.15-17 644 200.15-17 1098 200.15-17 1099 200.15-17 788 200.18 628

<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 Section Activity 200.01-14 627 200.01-14 627 200.01-14 627 200.01-14 627 200.15-17 644; 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-17 644 1098 1099 788 200.18 628 200.18 628

<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

### 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
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:

Replies
3
Views
211
Replies
1
Views
188
Replies
2
Views
349
Replies
0
Views
152
Replies
4
Views
145