A bit of power query help needed please.

I have a column with nested data that I need to expand, but I want to expand it in a transposed state, rather than what its currently doing which is creating a new duplicated row for very new data point. e.g.

Current Data
Row- -Col1- -Col2-  -Col3-  -Col4
1- --- -A- ---- -B- --- -C- --- -{nested}
2- --- -D- ---- -E- --- -F- --- -{nested}

the nested data looks like this:
Row-  -Col1-  -Col2
1---   --AA--   --22
2---   --AB--   --33
3---   --AC--   --44

What I want it to look like once it has been expanded is:

Row-  -Col1-  -Col2-   -Col3-   -AA--    -AB--    -AC
1---   ---A---   ---B---   --C--  --22--   --33--  --44
2---   ---D---   ---E---  ---F--  --19--   --92--   -87


What I am getting is:

Row-- --Col1-- --Col2-- --Col3-- --Col4-- --Col5
1--- ----A---- ----B---- ---C-- - ----AA---  ----22
2-- - ---A-- --- ---B-- - ---C---- ---AB---  ----33
3--- ----A----  ----B---- ---C--- ----AC---- ---44
4--- ----D--- -- ---E---- ---F--- - ---AA---- ---19
5-- - ---D--- --- --E-- --  --F--- -- --AB--- ----93
6---- ---D----  ----E-- - ---F-- -- ---AC---- ---87

Any ideas?

Help me B&B, you are my only hope!

One field with a fuck tonne of values, probably with a common separator, it's a case of letting them split out there, then referencing it later in a different table that 90 degrees to it

Ok, then yeah, if it's a column with multiple discreet info, split it. Either by characters or spaces or delimiters if they've been smart enough to leave punctuation.

Once you have all the data in sep columns, then moving and or unpivot should get you any combo you want.

Am also intrigued. I do a thing to split UK postcodes in SQL easy, tried doing it in Excel, and it fuckered me. Splitting out a string into substrings based in separator is possible but still difficult to match up pro pp perly

I'll need to see at least a pic, because I can't see how to do it unless the nested data leaves things with matching number of columns and rows.

This might be a question for @davyk: Does buying Windows 10 Pro give you basic office suite as well?

https://www.microsoft.com/en-gb/microsoft-365/enterprise/microsoft-365-apps-for-enterprise-product?activetab=pivot:overviewtab

Enterprise might be the way to go. £11.50 per user per month.

Aye. W 10 doesnt inc. Office of any flsvour.

We have an enterprise sub. A sub is the way to go nowadays.

Our IT contractors installed Sophos on all of our Macs as well and it’s a fucking pain in the arse. Slows everything down.

Thanks Davy. Have emailed sophos, donuts so far.

Next issue appears to be pdf. 

Outside of paying for adobe, what's easiest for getting signatures etc?

It appears folks have signed up for free adobe, then it runs out etc etc. It's just a big mess of computer says no when folks try and group sign something.

Interviewed for a ft/permanent role very similar to what I was doing at same org earlier this year.

Find out next week. Cross everything folks.

Could be a compromised account at their end.

We will try and contact someone in a source organisation when we get emails like that.

Hurrah!