Dear all, Cell A & B having data like below.please note that Data range of cell A & B is not fixed.
CELL A CELL B
AN NA
A R-1: 71 (19/ 6/ 46)
B R-3: 61 (19/ 7/ 35)
R-1 DH: 33 (7/ 2/ 24)
R-1 MG: 7 (5/ 0/ 2)
R-3 PB: 5 (2/ 0/ 3)
R-1 MN: 22 (5/ 3/ 14)
R-3 BO: 12 (2/ 3/ 7)
R-3 BR: 3 (1/ 0/ 2)
R-1 TN: 3 (2/ 1/ 0)
R-3 RS: 4 (2/ 1/ 1)
R-3 JD: 8 (2/ 1/ 5)
R-3 CN: 5 (2/ 0/ 3)
R-3 JS: 5 (1/ 0/ 4)
R-3 KT: 4 (0/ 1/ 3)
R-1 GP: 4 (0/ 0/ 4)
I want to get like below format in the Cell C
Site outage*status at 00:00 hrs.
Region: Total ( >1 / >3 / > 5 Hrs)
R-1: 71 (19/ 6/ 46)
R-3: 61 (19/ 7/ 35)
District R1 : Total ( >1 / >3 / > 5 Hrs)
DH: 33 (7/ 2/ 24)
MG: 7 (5/ 0/ 2)
MN: 22 (5/ 3/ 14)
TN: 3 (2/ 1/ 0)
GP: 4 (0/ 0/ 4)
District R3: Total ( >1 / >3 / > 5 Hrs)
PB: 5 (2/ 0/ 3)
BO: 12 (2/ 3/ 7)
BR: 3 (1/ 0/ 2)
RS: 4 (2/ 1/ 1)
JD: 8 (2/ 1/ 5)
CN: 5 (2/ 0/ 3)
JS: 5 (1/ 0/ 4)
KT: 4 (0/ 1/ 3)
Please check the attachment.
Bookmarks