A colleague has created a table with data headers in alternate rows. I need to convert this to data in separate columns to create a chart. So data is in alternate rows Fred/Dave Fred/Dave Fred/Dave etc. I need to extract the data into a column for Fred and a column for Dave. So in effect a formula to do a copy - paste/transpose. Many thanks.
|