Index by row, every "~" transpose into new line

[larrytura]

Hello I have an Index problem and I may not be asking about it right.
I want to transpose row into columns of varying number of rows, but all new record has an "~"where I want the break
example :
~SIG4-3
ADD=1-1-3
NAM=SIG4-3
LAB=CORRIDOR K SIG4-3
BAN=AV
DT=AV
PT=AV
STY = INDOOR
OP = GENERAL EVAC
CAN = 30
TON = BROADBAND
CT = TEMPORAL
VOL = HIGH
LNS = NO
C =0-
T =0-
D =0-
~SIG4-4
ADD=1-1-4
NAM=SIG4-4
LAB=STAFF RR CORR K SIG4-4
BAN=VO
DT=VO
PT=VO
STY = INDOOR
OP = GENERAL EVAC
CAN = 15
LNS = NO
C =0-
T =0-
D =0-
~SIG4-5
ADD=1-1-5
NAM=SIG4-5
LAB=KITCHEN SIG4-5
BAN=AV
DT=AV
PT=AV
STY = INDOOR
OP = GENERAL EVAC
CAN = 30
TON = BROADBAND
CT = TEMPORAL
VOL = HIGH
LNS = NO
C =0-
T =0-
D =0-
into columns:
~SIG4-3 ADD=1-1-3 NAM=SIG4-3 LAB=CORRIDOR K SIG4-3 BAN=AV DT=AV PT=AV STY = INDOOR OP = GENERAL EVAC CAN = 30 TON = BROADBAND CT = TEMPORAL VOL = HIGH LNS = NO C =0- T =0- D =0-
~SIG4-4 ADD=1-1-4 NAM=SIG4-4 LAB=STAFF RR CORR K SIG4-4 BAN=VO DT=VO PT=VO STY = INDOOR OP = GENERAL EVAC CAN = 15 LNS = NO C =0- T =0- D =0-
~SIG4-5 ADD=1-1-5 NAM=SIG4-5 LAB=KITCHEN SIG4-5 BAN=AV DT=AV PT=AV STY = INDOOR OP = GENERAL EVAC CAN = 30 TON = BROADBAND CT = TEMPORAL VOL = HIGH LNS = NO C =0- T =0- D =0-
Help please if possible, I know this is a complicated one. Thanks Larry

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.