Hello,
my name is Michael and I hope somebody can help me.
I attached an image to describes my issue.
I have a large sheet with ~80000 rows and ~5000 columns and I would like to concatenate some columns.
I am able to do what I want manually, but I need a more efficient way.
I don't know how to teach excel to continue following sequences:
Row-1: Every third cell: B1,E1,H1,...
Row-2: Concatenate B2,C2,D2|E2,F2,G2|H2,I2,J2|K2,..
Best regards from Vienna
Michael
concatenate-columns.PNG
Bookmarks