Transpose a table

Hi,

I need the day across the top of this table and the visits/ orders etc along the rows, how can I transpose this table ?

any help appreciated!

Best Answers

  • ColemenWilson
    Answer ✓

    Chart Properties > General > Transpose

    If I solved your problem, please select "yes" above

  • Jim_Smallhoover
    Answer ✓

    You would want to change the chart type to Pivot Table. Change from 'Popular Charts' to 'Tables and Textboxes' and in there you can choose Pivot table. Your Column would be the date and the rows would be your Marketing visits.

Answers

  • ColemenWilson
    Answer ✓

    Chart Properties > General > Transpose

    If I solved your problem, please select "yes" above

  • Jim_Smallhoover
    Answer ✓

    You would want to change the chart type to Pivot Table. Change from 'Popular Charts' to 'Tables and Textboxes' and in there you can choose Pivot table. Your Column would be the date and the rows would be your Marketing visits.