2 Replies Latest reply on Jun 1, 2016 9:59 PM by Kumar.0001

    Working with excel's merged cells

    Kumar.0001

      Hi all, I often have to work with excel sheets where two cells are merged to form a column name. As you can see, Jan is the merged column with Profit and sales inside it. Capture.PNG This creates problem as tableau is not able to read the dimensions and measures correctly. Is there a way I could program tableau to read the columns as JanProfit, Jansales,FebProfit and Febsales. I am attaching my workbook and data file. Please help.