Note: The other languages of the website are Google-translated. Back to English
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 27 May 2022
  1 Replies
  2K 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
2 months 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.
Be one of the first to reply to this post!