chv288115
New member
- Joined
- May 17, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I have text in a notepad like below.
UserGroupId = 61e65be5-d086-4840-85ac-490cad5d6f6e
Name = Access Care Universal
Description = Assignment group for FDR 3972
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = e61e1255-2d2a-43aa-b221-8182a76204dc
Name = Application Owners
Description = [Empty]
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = ece84749-bb13-4214-83fd-7de4d9782b93
Name = ApplicationOwnersLDAP
Description = [Empty]
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = 138b0cd2-0542-4205-9a6a-b0fea81e3ed6
Name = BBMSupport
Description = OTSS application group
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = 43537523-4595-43fa-8eea-7e8bdacb34e3
Name = BELLCANMO
Description = OTSS application group
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = 70865114-8d3d-4432-8ed0-0c4bc75843ba
Name = BlueprintsInfinite
Description = OTSS application group
EventAssignment = true
LdapAutoAssignment = false
I want the data to be converted into an Excel sheet like shown in the below image. [Above data and below image doesn't represent the same values of data]
For understanding, I have posted a data sample here, but I got a Few MB Text file with the same type of values and doing it manually will be a nightmare.
Does anyone have any ideas? If some one needed i have attached the original Notepad here.
FYI... I am using Office 365 Desktop Version.
What i have tried ?
I have tried exporting the data from Notepad and and used power query editor. Since, i am very less experienced with Power Query Editor i do have less luck.
UserGroupId = 61e65be5-d086-4840-85ac-490cad5d6f6e
Name = Access Care Universal
Description = Assignment group for FDR 3972
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = e61e1255-2d2a-43aa-b221-8182a76204dc
Name = Application Owners
Description = [Empty]
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = ece84749-bb13-4214-83fd-7de4d9782b93
Name = ApplicationOwnersLDAP
Description = [Empty]
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = 138b0cd2-0542-4205-9a6a-b0fea81e3ed6
Name = BBMSupport
Description = OTSS application group
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = 43537523-4595-43fa-8eea-7e8bdacb34e3
Name = BELLCANMO
Description = OTSS application group
EventAssignment = true
LdapAutoAssignment = false
UserGroupId = 70865114-8d3d-4432-8ed0-0c4bc75843ba
Name = BlueprintsInfinite
Description = OTSS application group
EventAssignment = true
LdapAutoAssignment = false
I want the data to be converted into an Excel sheet like shown in the below image. [Above data and below image doesn't represent the same values of data]
For understanding, I have posted a data sample here, but I got a Few MB Text file with the same type of values and doing it manually will be a nightmare.
Does anyone have any ideas? If some one needed i have attached the original Notepad here.
FYI... I am using Office 365 Desktop Version.
What i have tried ?
I have tried exporting the data from Notepad and and used power query editor. Since, i am very less experienced with Power Query Editor i do have less luck.
Attachments
Last edited: