archiveOnline Learning

Excel is a very useful tool in data analysis, and it's always a good thing to master as many skills as you can to save time and effort at work. One common question is: how can I convert a cross table (a.k.a. two-dimensional table) to a flat list (a.k.a. one-dimensional list) in Excel? Although flat list is the ideal form for analyzing, the data we get in daily life usually appear as cross tables so it's necessary to know how to do the conversion. Cross table & flat list If...