Merge Variables in Table

I would like to create a for loop which can merge variables dynamically by first letter, excluding the number standing behind the letter.

from this:

to this:

Thanks!

Answer 1

[Walter Roberson]

names = YourTable.Properties.VariableNames;
initials = extractBefore(names, 2);
[G, id] = findgroups(initials);
newTable = table();
for K = 1 : length(id)
   newTable.(id{K}) = [YourTable{:,G==K}];
end

[Alexandra Kopaleyshvili]

Hey Walter, thank you very much!

Is it possible to combine those multicolumn variables (like B or L) into single-column-variables (as shown in the second picture)?

[Alexandra Kopaleyshvili]

Ok i got it! I just needed to add this to your code:

for jj=1:width(newTable)
    size(newTable.(jj))
    if ans(1,2)> 1
alinear = {newTable.(jj){:}}'
{cat(1, alinear{:})}
newTable.(jj)=ans
    end
end