SQL Server 2016

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

(No column name)
1\|data1\|data2\|data3\|data4 2\|data5\|data6\|data7\|data8

ID	AsAString
1	1\|data1\|data2\|data3\|data4
2	2\|data5\|data6\|data7\|data8