Hello,Welcome to the Microsoft Tech Community,
here is the Microsoft documentation about Get & Transform in Excel (applies to Excel for Office 365 Excel 2019 Excel 2016)
I Hope it helps but if it doesn't Please consider posting your question in the dedicated Excel forum with many professionals and members available to help you out further for your Excel related issue.
Thank you! have a nice day
@HotCakeX Thanks for the response and help!
@milesvet I've moved this post to the Excel community.