transpose the news and split data stuff