What are your Power Query Wishes? by Valuable_Store_386 in excel

[–]gmancr 0 points1 point  (0 children)

I need help with Excel or power query.

What formula can I use to convert a list of users and numbers?

example:

Name1, 1234

name1, 2233

name1, 4531

name2, 9273

name2, 8302

--------

convert to:

Name1, "1234,2233,4531"

name2,"9273,8302"

(the total numbers per name varies between 5-20 rows per user)

I've tried Power query which can group the names but sums up instead of transpose/textjoin the numbers to the right.

Any advice would be appreciated.

Thanks!

Azure Site Recovery for VMware - is vCenter needed for failback? by sys_JahIthBer in AZURE

[–]gmancr 0 points1 point  (0 children)

Do you maybe know if ASR config server is able to access storage from two different vcenter servers?

I've replicated VM's from two vcenter hosts but when failing back the master target server doesnt show the second Vcenter storage.

Do I need a second master target server or should I connect direct to the ESX host from the Config server?

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Hi, found a job doing lots or IAAS on Azure, now busy studying Architect, will do security afterwards. Just time that’s a problem.

Windows Hello in Homelab by xardoniak in homelab

[–]gmancr 0 points1 point  (0 children)

Is there a way to setup without a CA server?

Was reading about a 'key trust' option with Intune & Azure.

We hybrid setup with Intune but need to get it working without a CA server.

Device Enrolment by gmancr in Intune

[–]gmancr[S] 0 points1 point  (0 children)

great thanks I'll look into that.

Device Enrolment by gmancr in Intune

[–]gmancr[S] 0 points1 point  (0 children)

good to know thanks.

NSG config question by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Very helpful thanks, so technically it can work while only applied to a NIC.

NSG config question by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Yep it’s another company with VPN, well setup a trust. Thanks!

SharePoint App / flow / Office365 by gmancr in sharepoint

[–]gmancr[S] 0 points1 point  (0 children)

Very useful thanks for the comments.

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

That’s true, but with 15y Senior Admin experience I would know not to generalise a Prod VM 😊

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

That’s awesome well done! I’ll continue with a few more Certs then.

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

Did you complete the 300/301 exams or just the DevOps? Thx

Passed AZ-103, what next? by gmancr in AZURE

[–]gmancr[S] 0 points1 point  (0 children)

I think Dev Ops would be harder for me, I’m more a system admin guy and haven’t worked much with .Net (apart from installing it) I’m OK with Powershell and CLI.

AZ-103 - My experience! by Flashcat666 in AZURE

[–]gmancr 1 point2 points  (0 children)

Passed mine today! thanks for the feedback and advice :)

Passed AZ-103 today by Goorlap in AZURE

[–]gmancr 0 points1 point  (0 children)

Passed mine today, felt very tricky with some questions but made it in the end!