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.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

Worked perfect!!

[Glenn Kennedy]

Yes, I was matching against IDs, not contracts.