formatting with blank cells

Question

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 NameSSNSourceTickerFundElection %Douthard, William J111-11-1111      Employee Pre-tax      PMF0003Planmark Moderate 60/40100        Match      PMF0003Planmark Moderate 60/40100        Profit Sharing      PMF0003Planmark Moderate 60/40100        Rollover Pre-tax      PMF0003Planmark Moderate 60/40100        Employer QNEC      PMF0003Planmark Moderate 60/40100            Allen, Wesley222-22-2222      Employee Pre-tax      VTMGXVanguard Developed Markets Index Admiral40   VIGAXVanguard Growth Index Admiral30   VTIAXVanguard Total Intl Stock Index Admiral30        Match      VTMGXVanguard Developed Markets Index Admiral40   VIGAXVanguard Growth Index Admiral30   VTIAXVanguard Total Intl Stock Index Admiral30

How I want it to look

PPT NameSSNSourceTickerFundElection %Douthard, William J111-11-1111Employee Pre-taxPMF0003Planmark Moderate 60/40100Douthard, William J111-11-1111MatchPMF0003Planmark Moderate 60/40100Douthard, William J111-11-1111Profit SharingPMF0003Planmark Moderate 60/40100Douthard, William J111-11-1111Rollover Pre-taxPMF0003Planmark Moderate 60/40100Douthard, William J111-11-1111Employer QNECPMF0003Planmark Moderate 60/40100Allen, Wesley222-22-2222Employee Pre-taxVTMGXVanguard Developed Markets Index Admiral40Allen, Wesley222-22-2222Employee Pre-taxVIGAXVanguard Growth Index Admiral30Allen, Wesley222-22-2222Employee Pre-taxVTIAXVanguard Total Intl Stock Index Admiral30Allen, Wesley222-22-2222MatchVTMGXVanguard Developed Markets Index Admiral40Allen, Wesley222-22-2222MatchVIGAXVanguard Growth Index Admiral30Allen, Wesley222-22-2222MatchVTIAXVanguard Total Intl Stock Index Admiral30

ccanterman · Accepted Answer

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

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