How to use codes and organizing data from a secondary source

%3CLINGO-SUB%20id%3D%22lingo-sub-1935083%22%20slang%3D%22en-US%22%3EHow%20to%20use%20codes%20and%20organizing%20data%20from%20a%20secondary%20source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935083%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20I'm%20not%20any%20sort%20of%20expert%20in%20excel%20at%20all.%20I'm%20trying%20to%20figure%20out%20how%20to%20use%20my%20codebook%20from%20the%20CDC%20website%20to%20organize%20my%20data.%20Where%20do%20I%20start%3F%20I%20have%20a%20million%20columns%20to%20sort.%20I've%20already%20marked%20down%20in%20a%20notebook%20the%20data%20I%20need%2C%20I%20need%20help%20cutting%20down%20the%20data.%20HELP!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1935083%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1935194%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20use%20codes%20and%20organizing%20data%20from%20a%20secondary%20source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935194%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883071%22%20target%3D%22_blank%22%3E%40Redd2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20the%20first%20bit%20of%20help%20is%20something%20you'll%20have%20to%20do%20yourself%2C%20I'm%20afraid.%20Right%20now%2C%20it's%20clear%20you're%20overwhelmed%20by%20the%20enormity%20of%20the%20task%20facing%20you.%20But%20in%20order%20for%20anybody%20at%20a%20distance%20to%20help%2C%20you're%20going%20to%20need%20to%20become%20a%20bit%20more%20specific%20in%20what%20comprises%20those%20%22million%20columns%22%20of%20data%2C%20what%20kind%20of%20data%20it%20is%2C%20what%20you%20want%20to%20do%20with%20it.%20Quite%20a%20bit%20more%20specific%2C%20in%20fact.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20can%2C%20assuming%20this%20is%20all%20data%20in%20the%20public%20domain%2C%20you%20could%20post%20a%20copy%20of%20what%20you're%20looking%20at%20here%20on%20this%20website.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20also%2C%20seriously%2C%20what%20is%20your%20goal%20in%20sorting%20through%20it%3F%20There%20are%20multiple%20ways%20to%20do%20sift%20and%20sort%20data%20in%20Excel%2C%20but%20it%20would%20not%20be%20helpful%20to%20you%20as%20a%20novice%20with%20Excel%20for%20anybody%20to%20give%20general%20or%20abstract%20directives.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello I'm not any sort of expert in excel at all. I'm trying to figure out how to use my codebook from the CDC website to organize my data. Where do I start? I have a million columns to sort. I've already marked down in a notebook the data I need, I need help cutting down the data. HELP!!

1 Reply

@Redd2020 

 

Well, the first bit of help is something you'll have to do yourself, I'm afraid. Right now, it's clear you're overwhelmed by the enormity of the task facing you. But in order for anybody at a distance to help, you're going to need to become a bit more specific in what comprises those "million columns" of data, what kind of data it is, what you want to do with it. Quite a bit more specific, in fact. And what is that "codebook" from the CDC?

 

If you can, assuming this is all data in the public domain, you could post a copy of what you're looking at here on this website.

 

But also, seriously, what is your goal in sorting through it? There are multiple ways to do sift and sort data in Excel, but it would not be helpful to you as a novice with Excel for anybody to give general or abstract directives.