Create Excel tables. And enjoy a selection of advanced Excel training videos that will upgrade your skills. Consolidation of data from two columns into one column. Split data into separate columns. Conditional design - anyone can! Excel function to calculate frequency