Help with Excel (MacOS) formula for duplicating rows with unique data in certain columns

Hi Britt and welcome to the forum,

I'm not sure if your version of Excel has Power Query yet. But, using my PC with Excel 365 and the 2010 tool called Power Query your problem is pretty easy. The secret is to UnPivot Other columns. I took your data from sheet1 and did PQ on it using UnPivot Other columns and then removed blank rows of Phone numbers and see sheet2. (I really trimmed the phone numbers before I removed blanks)

Does that help? See attached: UnPivot Other for Britt.xlsx

OK Britt,

Long before Power Query and UnPivot I wrote some VBA code to do a similar thing.

I've added that VBA to the attached file. Warning - make a backup of your data to run this macro on. See if it does what you want.
You have 3 Fixed columns, First, Last and Address. See my Start sheet and run the macro on it. Copy your data into this sheet and run the macro again. (Keep your fingers crossed)
Make CrossTab a Table for Britt.xlsm

Hi Britt,
I assum output data is from K2:

In K2:=A2
Copy to L2
K3:

Please Login or Register  to view this content.

Copy to L3
M2:
=LOOKUP(2,1/($A$2:$A$5=$K2)/($B$2:$B$5=$L2),$C$2:$C$5)
N2 (array formula, confirm by Ctrl-shift-enter)
=INDEX($D$1:$F$5,MATCH($K2&$L2,$A$1:$A$5&$B$1:$B$5,0),AGGREGATE(15,6,COLUMN($D:$F)/(INDEX($D$1:$F$5,MATCH($K2&$L2,$A$1:$A$5&$B$1:$B$5,0),)<>""),COUNTIFS($K$2:$K2,$K2,$L$2:$L2,$L2))-3)

Hey Britt,
We all work for free and to get a good "Thank You" like you gave. We also appreciate "Add Reputation" points. Click on the "* Add Reputation" below the answer(s) you like and give a comment.

Originally Posted by Britt23

WOW - Amazing! This worked like a charm!!!

Haha, nice to hear it works . We're all volunteers working for our own hobby.