Home

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
Related Conversations
Restrict Edit access on columns on user/group basis.
Vimmi Rawat in SharePoint on
0 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies
Last Value Column from Another Column in Same List
Yepitsme in SharePoint on
6 Replies
Change default views for subfolders
mlilindstrom in SharePoint on
2 Replies