Hi Xcel Guru - Kindly help on this. I have the below table from Column A to Column R. I have data in two rows: 3 & 4.

'Quote Registration (1)' is merged from Column A to Column C;
'Policy Information (2)' is merged from Column D to Column F;
Likewise, 'Billing Information (5)' is merged from Column P to Column R;

Quote Registration (1) Policy Information (2)
Buildings (3) Locations (3) Other Interest List Details (4) Billing Information (5)
Role1 Role2 Role3 Role1 Role2 Role3 Role1 Role2 Role3 Role1 Role2 Role3 Role1 Role2 Role3 Role1 Role2 Role3
N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A Premium Billing Address abc/xyz so print bcd/mno so print
Quote Reg hidden hidden Policy Info hidden hidden Building hidden hidden NA NA NA Other Interest hidden hidden Premium Billing Address hidden hidden


I need below output for the 'Screen Name': If column 'Role1' has other than 'N/A', print A1:C1 which is 'Quote Registration'. Based on the above table, my output (for 1st row and 2nd row respectively) should be exactly like this which also needs to be pre-fixed with 1, 2, 3, 4, 5


Screen Name
1. Billing Information (Column P1:R1 excluding number (5) from the cell)
1. Quote Registration (Column A1:C1 excluding number (1) from the cell)
2. Policy Information (D1:F1)
3. Buildings (G1:I1)
4. Other Interest List Details (M1:O1)
5 . Billing Information (P1:R1)


I need below exact output for 'Roles':
Roles
1. Role2: abc/xyz so print
Role3: bcd/mno so print
1. Role2: hidden
Role3: hidden
2. Role2: hidden
Role3: hidden
3. Role2: hidden
Role3: hidden
4. Role2: hidden
Role3: hidden
5. Role2: hidden
Role3: hidden