Requesting Formula for Re-Formatting Text

I have a block of text in the following format:

DOE, JOHN

12345 MAIN ST
STE 320
OAKLAND, CA 12345

P: 1234567890
F: 0987654321

Service Date
01/11/2019 ~ 11/11/2019

I have to re-format this text two ways:

1. In a single line, with the following result:

DOE, JOHN, 12345 MAIN ST STE 320, OAKLAND, CA 12345, (123)456-7890

2. In a block, with the following result:

DOE, JOHN
12345 MAIN ST STE 320
OAKLAND, CA 12345
P: 1234567890
F: 0987654321
Service Date: 01/11/2019 ~ 11/11/2019

Every detail must appear as shown, including parentheses, or lack thereof, removing line spaces, etc.

Can anyone help me produce some formulas to re-format the text in both ways?

Note: This needs to be done just using formulas (no macros, VBA, etc.). Work computer will not allow anything fancy.

Brilliant! Thank you so much!

I don't think just removing duplicates produces the required "block" output (if that was the intent).
- "STE 320" needs to follow the street address on the same line
- Service Date & ": " and the pair of dates needs to be on the same line

Starting with Kev's SHEET1 layout, in cell C1:

Formula:

Please Login or Register  to view this content.

Make sure that "Wrap text" is on for cell C1 and that it is wide enough to accommodate each line's width.

@H3br3wHamm3r81 - thanks for the rep points