Friday, 27 May 2022
  1 Replies
  6.3K Visits
0
Votes
Undo
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
1 year ago
·
#2761
0
Votes
Undo
Okay, withdrawing the question. Transpose Range did the job using the Fixed value field.
After making the raw data consistent, this worked fine.
  • Page :
  • 1
There are no replies made for this post yet.