Filtered columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1096819%22%20slang%3D%22en-US%22%3EFiltered%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096819%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20several%20columns%2C%20lets%20say%20a%2C%20b%2C%20c%2C%20d.%20I%20need%20them%20to%20be%20in%20a%20filtered%20column%20but%20show%20up%20as%20individual%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFilltered%20Column%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BColumn1%26nbsp%3B%20%26nbsp%3BColumn%202%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BColumn%203%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Column%204%3C%2FP%3E%3CP%3Ea%2C%20b%2C%20c%2C%20d%2C%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20a%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bb%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20c%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bd%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20want%20to%20remove%20Columns%201%20-%204.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20filter%20column%20to%20be%20able%20to%20sort%20for%20a%2C%20for%20example%2C%20without%20giving%20me%20every%20combination%20that%20contains%20a.%20Same%20with%20b%2C%20etc.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164263i3194A586D1514B60%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1096819%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1098025%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098025%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F510598%22%20target%3D%22_blank%22%3E%40TCD333%3C%2FA%3E%26nbsp%3BI%20tried%20really%20hard%20to%20understand%20what%20would%20you%20like%20to%20achieve%2C%20but%20I%20couldn't.%20Could%20you%20be%20more%20clear%20about%20what%20would%20you%20like%20to%20achieve%3F%3F%20It%20may%20help%20also%20attaching%20the%20file%20you%20are%20working%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EBranka%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1098190%22%20slang%3D%22en-US%22%3ERe%3A%20Filtered%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098190%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20question%20isn't%20straight%20forward%20to%20understand.%20Kindly%20re-work%20the%20question%3C%2FLINGO-BODY%3E
Highlighted
Visitor

I have several columns, lets say a, b, c, d. I need them to be in a filtered column but show up as individual data. 

 

Filltered Column         Column1   Column 2       Column 3        Column 4

a, b, c, d,                          a               b                      c                     d

 

Then I want to remove Columns 1 - 4.

I would like to filter column to be able to sort for a, for example, without giving me every combination that contains a. Same with b, etc.

clipboard_image_0.png

2 Replies
Highlighted

@TCD333 I tried really hard to understand what would you like to achieve, but I couldn't. Could you be more clear about what would you like to achieve?? It may help also attaching the file you are working on.

 

Thanks,

Branka

Highlighted
Hello,

The question isn't straight forward to understand. Kindly re-work the question