I have two columns of values. The first column values repeat and are effectively my headers so transposition is not an issue.
It's the second column where I want to bulk transpose values as they relate to the first column to ROWS.
example:
ColumnA ColumnB
Vserver w11_pdcpflr018
File Path /mobility_shared
Security Style ntfs
Effective Style ntfs
Owner BUILTIN\administrators
Group BUILTIN\administrators
DACL - ACEs "ALLOW-Everyone-0x1f01ffALLOW-Everyone-0x10000000-OI|CI|IO"
Vserver w11pscvfvmpr001
File Path /prd_marketing_archive
Security Style ntfs
Effective Style ntfs
Owner BUILTIN\administrators
Group BUILTIN\administrators
DACL - ACEs "ALLOW-LUV\Domain Admins-0x1f01ff-OI|CIALLOW-LUV\Domain Users-0x1200a9"
How do I select a range of rows in ColumnB to transpose into multple rows aligned with these headers?
Vserver File Path Security Style Effective Style Owner Group DACL - ACEs
It's the second column where I want to bulk transpose values as they relate to the first column to ROWS.
example:
ColumnA ColumnB
Vserver w11_pdcpflr018
File Path /mobility_shared
Security Style ntfs
Effective Style ntfs
Owner BUILTIN\administrators
Group BUILTIN\administrators
DACL - ACEs "ALLOW-Everyone-0x1f01ffALLOW-Everyone-0x10000000-OI|CI|IO"
Vserver w11pscvfvmpr001
File Path /prd_marketing_archive
Security Style ntfs
Effective Style ntfs
Owner BUILTIN\administrators
Group BUILTIN\administrators
DACL - ACEs "ALLOW-LUV\Domain Admins-0x1f01ff-OI|CIALLOW-LUV\Domain Users-0x1200a9"
How do I select a range of rows in ColumnB to transpose into multple rows aligned with these headers?
Vserver File Path Security Style Effective Style Owner Group DACL - ACEs
- Page :
- 1
There are no replies made for this post yet.