Column formual

%3CLINGO-SUB%20id%3D%22lingo-sub-1555420%22%20slang%3D%22en-US%22%3EColumn%20formual%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555420%22%20slang%3D%22en-US%22%3EHi.%20I'm%20a%20beginner.%20I%20would%20please%20to%20now%20how%20to%20keep%20to%20cells%20%22married%22%3CBR%20%2F%3E%3CBR%20%2F%3EExample%3CBR%20%2F%3EunitA5%20w%2F%20%24D5%3CBR%20%2F%3EUnit%C3%806%20w%2F%20%24D6%3CBR%20%2F%3E.%3CBR%20%2F%3E.%3CBR%20%2F%3E.%3CBR%20%2F%3E.%3CBR%20%2F%3EUnitA14%26gt%3B.%20With%20%24D15%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20sort%20values%20in%20Collum%20%24D%3CBR%20%2F%3Ethe%20unit%20A%20moves%20together%20with%20%24D%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1555420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1555425%22%20slang%3D%22de-DE%22%3ERE%3A%20Column%20formual%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1555425%22%20slang%3D%22de-DE%22%3E%3DA14%26amp%3BD15%20with%20comma%20%3DA14%26amp%3B%22%2C%22%26amp%3BD15%20If%20you%20have%20solved%20your%20problem%20with%20this%20solution%2C%20please%20mark%20it%20as%20the%20correct%20answer%20so%20that%20others%20can%20also%20get%20this%20information.%20If%20this%20is%20not%20what%20you%20are%20looking%20for%2C%20please%20give%20us%20a%20quick%20feedback.%20Nikolino%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558164%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20formual%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744606%22%20target%3D%22_blank%22%3E%40Ryedar%3C%2FA%3E%26nbsp%3BBegin%20by%20deleting%20the%20empty%20columns%20and%20the%20empty%20row%20below%20the%20headers.%20That%20way%20you%20create%20an%20%22unbroken%22%20range%20of%20data.%20Then%20you%20can%20sort%20a%20column%20and%20the%20others%20follow%20with%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi. I'm a beginner. I would please to now how to keep to cells "married"

Example
unitA5 w/ $G5
UnitÀ6 w/ $G6
.
.
.
.
UnitA14>. With $D15

When I sort values in Collum $D
the unit A moves together with $D
2 Replies
=A14&D15 with comma =A14&","&D15 If you have solved your problem with this solution, please mark it as the correct answer so that others can also get this information. If this is not what you are looking for, please give us a quick feedback. Nikolino I know I don't know anything (Socrates)

@Ryedar Begin by deleting the empty columns and the empty row below the headers. That way you create an "unbroken" range of data. Then you can sort a column and the others follow with it.