Put items in different columns (group several rows with same contact id)

[mcfarris]

First an example:
testbook.xlsx

I have an extracted database file from our (soon to be) old CRM software. I want to put this in a SQL database where I want to divide the number column (wehre every kind of number resides) over dedicated columns per number (mobile, direct, office, etc).

I thought about a Pivot Table but a pivot table cant display the value of the table, only SUM, MAX, etc.

Does someone can give me a keyword or push in the right direction?

[Glenn Kennedy]

Hi there. Use the Array-Entered formula, below, as shown in the attached sheet.

=IFERROR(INDEX($C$2:$C$9,MATCH(1,($A15=$A$2:$A$9)*(C$14=$D$2:$D$9),0)),"")

An Array formula isconfirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Drag across & down, as needed.

[mcfarris]

Wonderful! altough I had to edit your forumula; it must check de Contacts ID column instead of the ID.

=IFERROR(INDEX($C$2:$C$9,MATCH(1,($B15=$B$2:$B$9)*(C$14=$D$2:$D$9),0)),"")

Worked perfect!!

[Glenn Kennedy]

Yes, I was matching against IDs, not contracts.