SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable(
   ID       INTEGER  NOT NULL PRIMARY KEY 
  ,ADDRESS1 VARCHAR(19) NOT NULL
  ,ADDRESS2 VARCHAR(23) NOT NULL
  ,CITY     VARCHAR(18) NOT NULL
  ,STATE    VARCHAR(10) NOT NULL
  ,ZIP      INTEGER  NOT NULL
);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (18047,'1 3rd St','Suite A','Hometown','NJ',08000);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (1045136,'1 3rd St','Suite A','Hometown','NJ',08000);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (2321,'1 3rd St','Suite A','Hometown','NJ',08000);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (3311,'1 3rd St','Suite A','Hometown','NJ',08000);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (3681,'1 3rd St','Suite A','Hometown','NJ',08000);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (1750,'1 Baker Rd','Ste C','Happy Hill','NJ',08111);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (1822,'1 Baker Rd','Ste C','Happy Hill','NJ',08111);
INSERT INTO mytable(ID,ADDRESS1,ADDRESS2,CITY,STATE,ZIP) VALUES (1935,'1 Baker Rd','Ste C','Happy Hill','NJ',08111);

SELECT
    address1
  , address2
  , city
  , state
  , zip
  , string_agg(id, '|') IDList
FROM mytable
GROUP BY address1
       , address2
       , city
       , state
       , zip
;

address1	address2	city	state	zip	IDList
1 3rd St	Suite A	Hometown	NJ	8000	2321\|3311\|3681\|18047\|1045136
1 Baker Rd	Ste C	Happy Hill	NJ	8111	1750\|1822\|1935

address1	address2	city	state	zip	IDList
1 3rd St	Suite A	Hometown	NJ	8000	2321\| 3311\| 3681\| 18047\| 1045136
1 Baker Rd	Ste C	Happy Hill	NJ	8111	1750\| 1822\| 1935