formatting with blank cells

[sericson]

I have a file that I can't figure out how to get the data into an easier to read format. I have samples of the before and what I need it to look like. is there a way to accomplish this?

How it looks now

PPT Name	SSN	Source	Ticker	Fund	Election %
Douthard, William J	111-11-1111
		Employee Pre-tax
			PMF0003	Planmark Moderate 60/40	100
		Match
			PMF0003	Planmark Moderate 60/40	100
		Profit Sharing
			PMF0003	Planmark Moderate 60/40	100
		Rollover Pre-tax
			PMF0003	Planmark Moderate 60/40	100
		Employer QNEC
			PMF0003	Planmark Moderate 60/40	100
Allen, Wesley	222-22-2222
		Employee Pre-tax
			VTMGX	Vanguard Developed Markets Index Admiral	40
			VIGAX	Vanguard Growth Index Admiral	30
			VTIAX	Vanguard Total Intl Stock Index Admiral	30
		Match
			VTMGX	Vanguard Developed Markets Index Admiral	40
			VIGAX	Vanguard Growth Index Admiral	30
			VTIAX	Vanguard Total Intl Stock Index Admiral	30

How I want it to look

PPT Name	SSN	Source	Ticker	Fund	Election %
Douthard, William J	111-11-1111	Employee Pre-tax	PMF0003	Planmark Moderate 60/40	100
Douthard, William J	111-11-1111	Match	PMF0003	Planmark Moderate 60/40	100
Douthard, William J	111-11-1111	Profit Sharing	PMF0003	Planmark Moderate 60/40	100
Douthard, William J	111-11-1111	Rollover Pre-tax	PMF0003	Planmark Moderate 60/40	100
Douthard, William J	111-11-1111	Employer QNEC	PMF0003	Planmark Moderate 60/40	100
Allen, Wesley	222-22-2222	Employee Pre-tax	VTMGX	Vanguard Developed Markets Index Admiral	40
Allen, Wesley	222-22-2222	Employee Pre-tax	VIGAX	Vanguard Growth Index Admiral	30
Allen, Wesley	222-22-2222	Employee Pre-tax	VTIAX	Vanguard Total Intl Stock Index Admiral	30
Allen, Wesley	222-22-2222	Match	VTMGX	Vanguard Developed Markets Index Admiral	40
Allen, Wesley	222-22-2222	Match	VIGAX	Vanguard Growth Index Admiral	30
Allen, Wesley	222-22-2222	Match	VTIAX	Vanguard Total Intl Stock Index Admiral	30

[Carolyn · Accepted solution]

I would do this with a few Multi-Row Tools. See attached

If this solves your question, please mark the post as Resolved

[sericson]

this worked! thank you so much